-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.36-community


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema litreviewtrial
--

CREATE DATABASE IF NOT EXISTS litreviewtrial;
USE litreviewtrial;

--
-- Definition of table `ashanal`
--

DROP TABLE IF EXISTS `ashanal`;
CREATE TABLE `ashanal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ashProdMethod` varchar(100) DEFAULT NULL,
  `CO2` double DEFAULT NULL,
  `SO3` double DEFAULT NULL,
  `P2O5` double DEFAULT NULL,
  `SiO2` double DEFAULT NULL,
  `Fe2O3` double DEFAULT NULL,
  `Al2O3` double DEFAULT NULL,
  `CaO` double DEFAULT NULL,
  `MgO` double DEFAULT NULL,
  `Na2O` double DEFAULT NULL,
  `K2O` double DEFAULT NULL,
  `TiO2` double DEFAULT NULL,
  `Pb` double DEFAULT NULL,
  `Cd` double DEFAULT NULL,
  `Cl` double DEFAULT NULL,
  `Cu` double DEFAULT NULL,
  `Hg` double DEFAULT NULL,
  `Mn` double DEFAULT NULL,
  `Cr` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  `cref_fk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_ash` (`id`),
  KEY `ref_ind_ash` (`ref_fk`),
  CONSTRAINT `exp_fk_ash` FOREIGN KEY (`id`) REFERENCES `experiment` (`ashanal_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_ash` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ashanal`
--

/*!40000 ALTER TABLE `ashanal` DISABLE KEYS */;
INSERT INTO `ashanal` (`id`,`ashProdMethod`,`CO2`,`SO3`,`P2O5`,`SiO2`,`Fe2O3`,`Al2O3`,`CaO`,`MgO`,`Na2O`,`K2O`,`TiO2`,`Pb`,`Cd`,`Cl`,`Cu`,`Hg`,`Mn`,`Cr`,`ref_fk`,`cref_fk`) VALUES 
 (1,'',NULL,NULL,NULL,NULL,NULL,NULL,0.295,0.188,0.025,2.53,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL),
 (2,'',NULL,NULL,NULL,NULL,NULL,NULL,0.295,0.188,0.025,2.53,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL),
 (3,'',NULL,NULL,NULL,NULL,NULL,NULL,0.239,0.128,0.024,1.24,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL);
/*!40000 ALTER TABLE `ashanal` ENABLE KEYS */;


--
-- Definition of table `calanal`
--

DROP TABLE IF EXISTS `calanal`;
CREATE TABLE `calanal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `moistureStatus` enum('as received','dry','dry ash-free') DEFAULT NULL,
  `HHV` double DEFAULT NULL,
  `LHV` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  `cref_fk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_cal` (`id`),
  KEY `ref_ind_cal` (`ref_fk`),
  CONSTRAINT `exp_fk_cal` FOREIGN KEY (`id`) REFERENCES `experiment` (`calanal_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_cal` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calanal`
--

/*!40000 ALTER TABLE `calanal` DISABLE KEYS */;
INSERT INTO `calanal` (`id`,`moistureStatus`,`HHV`,`LHV`,`ref_fk`,`cref_fk`) VALUES 
 (1,'as received',18.46,NULL,1,NULL),
 (2,'as received',18.74,NULL,1,NULL),
 (3,'as received',NULL,17,2,NULL),
 (4,'as received',16.97,NULL,2,NULL),
 (5,'as received',NULL,16.97,2,NULL),
 (6,'as received',16.97,NULL,2,NULL),
 (7,'as received',16.97,NULL,2,NULL),
 (8,'as received',16.97,NULL,2,NULL),
 (9,'as received',15.3,NULL,2,NULL),
 (10,'as received',15.3,NULL,2,NULL),
 (11,'as received',15.3,NULL,2,NULL),
 (12,'as received',15.3,NULL,2,NULL),
 (13,'as received',15.8,NULL,2,NULL),
 (14,'as received',15.8,NULL,2,NULL),
 (15,'as received',15.8,NULL,2,NULL),
 (16,'as received',15.8,NULL,2,NULL),
 (17,'as received',NULL,14.5,2,NULL),
 (18,'as received',NULL,14.5,2,NULL),
 (19,'as received',NULL,14.5,2,NULL),
 (20,'as received',NULL,14.5,2,NULL),
 (21,'as received',NULL,14.5,2,NULL),
 (22,'as received',NULL,14.5,2,NULL),
 (23,'dry',NULL,18.5,3,NULL),
 (24,'as received',NULL,18.5,3,NULL),
 (25,'as received',NULL,16.1,3,NULL),
 (26,'as received',NULL,16.1,3,NULL),
 (27,'as received',NULL,18.8,3,NULL),
 (28,'as received',NULL,18.8,3,NULL),
 (29,'as received',NULL,18.8,3,NULL),
 (30,'as received',NULL,18.8,3,NULL),
 (31,'as received',NULL,15.8,3,NULL),
 (32,'as received',NULL,15.8,3,NULL),
 (33,'as received',19.2,NULL,4,NULL),
 (34,'as received',19.2,NULL,4,NULL),
 (35,'as received',19.2,NULL,4,NULL),
 (36,'as received',19.2,NULL,4,NULL),
 (37,'as received',19.2,NULL,4,NULL),
 (38,'as received',19.2,NULL,4,NULL),
 (39,'as received',19.2,NULL,4,NULL),
 (40,'as received',19.2,NULL,4,NULL),
 (41,'as received',13,NULL,5,NULL),
 (42,'as received',13,NULL,5,NULL),
 (43,'as received',20,NULL,5,NULL),
 (44,'as received',18,NULL,7,NULL),
 (45,'as received',18,NULL,7,NULL),
 (46,'as received',18,NULL,7,NULL),
 (47,'as received',18,NULL,7,NULL),
 (48,'as received',18,NULL,7,NULL),
 (49,'as received',18,NULL,7,NULL),
 (50,'as received',18,NULL,7,NULL),
 (51,'as received',18,NULL,7,NULL),
 (52,'as received',18,NULL,7,NULL),
 (53,'as received',18,NULL,7,NULL),
 (54,'as received',18,NULL,7,NULL),
 (55,'dry',18.6,NULL,8,NULL),
 (56,'as received',16,NULL,9,NULL),
 (57,'as received',15.7,NULL,9,NULL),
 (58,'as received',16,NULL,9,NULL),
 (59,'as received',15.7,NULL,9,NULL),
 (60,'as received',15.7,NULL,9,NULL),
 (61,'as received',16,NULL,9,NULL),
 (62,'as received',16,NULL,9,NULL),
 (63,'as received',16,NULL,9,NULL),
 (64,'as received',16,NULL,9,NULL),
 (65,'as received',16,NULL,9,NULL),
 (66,'as received',16,NULL,9,NULL),
 (67,'as received',16,NULL,9,NULL),
 (68,'as received',16,NULL,9,NULL),
 (69,'as received',16,NULL,9,NULL);
/*!40000 ALTER TABLE `calanal` ENABLE KEYS */;


--
-- Definition of table `chrcomp`
--

DROP TABLE IF EXISTS `chrcomp`;
CREATE TABLE `chrcomp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `C` double DEFAULT NULL,
  `H` double DEFAULT NULL,
  `N` double DEFAULT NULL,
  `S` double DEFAULT NULL,
  `Ash` double DEFAULT NULL,
  `experiment_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `yds_ind_ccomp` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `chrcomp`
--

/*!40000 ALTER TABLE `chrcomp` DISABLE KEYS */;
INSERT INTO `chrcomp` (`id`,`C`,`H`,`N`,`S`,`Ash`,`experiment_id`) VALUES 
 (1,41.23,2.16,1.45,0.22,52.55,1),
 (2,32.28,1.87,1.02,0.06,46.54,2),
 (3,64.81,5,2.04,0.55,14.9,44),
 (4,74.25,2.91,0.78,0.74,10.06,45),
 (5,62.77,2.81,0.72,0.62,38.37,46),
 (6,63.09,3.71,0.78,NULL,26.87,58),
 (7,80.2,2.4,0.2,NULL,NULL,76),
 (8,58.5,5,0.3,NULL,NULL,74),
 (9,73.8,3.4,0.3,NULL,NULL,75),
 (10,82.2,1.6,0.2,NULL,NULL,77),
 (11,84.4,1.3,0.5,NULL,NULL,78),
 (12,87.2,0.8,0.8,NULL,NULL,79),
 (13,89.2,0.6,1,NULL,NULL,80),
 (14,80.2,2.6,0.3,NULL,NULL,81),
 (15,81.8,2.8,0.2,NULL,NULL,82),
 (16,81.8,2.8,0.2,NULL,NULL,83),
 (18,NULL,NULL,NULL,NULL,NULL,4);
/*!40000 ALTER TABLE `chrcomp` ENABLE KEYS */;


--
-- Definition of table `convconditions`
--

DROP TABLE IF EXISTS `convconditions`;
CREATE TABLE `convconditions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `conv_Regime` varchar(50) DEFAULT NULL,
  `reactorConfig` varchar(100) DEFAULT NULL,
  `bedMedium` varchar(50) DEFAULT NULL,
  `feedSystem` varchar(100) DEFAULT NULL,
  `gasificationMed` varchar(50) DEFAULT NULL,
  `gasBiomassRatio` double DEFAULT NULL,
  `feedRate_min` double DEFAULT NULL,
  `feedRate_max` double DEFAULT NULL,
  `temp` double DEFAULT NULL,
  `pressure` double DEFAULT NULL,
  `heatRate_min` double DEFAULT NULL,
  `heatRate_max` double DEFAULT NULL,
  `resTime_min` double DEFAULT NULL,
  `resTime_max` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  `sweptGasVelocity` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_conv` (`id`),
  KEY `ref_ind_conv` (`ref_fk`),
  CONSTRAINT `exp_fk_conv` FOREIGN KEY (`id`) REFERENCES `experiment` (`convcond_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_conv` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `convconditions`
--

/*!40000 ALTER TABLE `convconditions` DISABLE KEYS */;
INSERT INTO `convconditions` (`id`,`conv_Regime`,`reactorConfig`,`bedMedium`,`feedSystem`,`gasificationMed`,`gasBiomassRatio`,`feedRate_min`,`feedRate_max`,`temp`,`pressure`,`heatRate_min`,`heatRate_max`,`resTime_min`,`resTime_max`,`ref_fk`,`sweptGasVelocity`) VALUES 
 (1,'Pyrolysis','Bubbling Fluidized Bed','Sand','Gravimeter Feeder with variable speed auger','Nitrogen',0.46,0.96,1.41,490,NULL,63.8,76.3,0.1,NULL,1,NULL),
 (2,'Pyrolysis','Bubbling Fluidized Bed','Sand','Gravimeter Feeder with variable speed auger','Nitrogen',0.46,0.832,1.481,487.7,NULL,70.58,72.6,0.1,NULL,1,NULL),
 (3,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,4.5,NULL,2,NULL),
 (4,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,4.5,NULL,2,NULL),
 (5,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,4.5,NULL,2,NULL),
 (6,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,4.5,NULL,2,NULL),
 (7,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,4.5,NULL,2,NULL),
 (8,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,4,NULL,2,NULL),
 (9,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,4.5,NULL,2,NULL),
 (10,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,4.5,NULL,2,NULL),
 (11,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,4.5,NULL,2,NULL),
 (12,'Pyrolysis','Fixed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,4.5,NULL,2,NULL),
 (13,'Pyrolysis','Fixed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,NULL,NULL,2,NULL),
 (14,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,NULL,NULL,2,NULL),
 (15,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,NULL,NULL,2,NULL),
 (16,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,NULL,NULL,2,NULL),
 (17,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,10,NULL,NULL,NULL,2,NULL),
 (19,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,NULL,NULL,2,NULL),
 (20,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,NULL,NULL,2,NULL),
 (21,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,650,NULL,30,NULL,NULL,NULL,2,NULL),
 (22,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.8,NULL,0.066,650,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (23,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.8,NULL,0.058,780,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (24,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.8,NULL,0.066,650,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (25,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.8,NULL,0.058,780,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (26,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.5,NULL,0.056,750,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (27,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',2.5,NULL,0.056,750,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (28,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.8,NULL,0.058,650,NULL,NULL,NULL,NULL,NULL,3,NULL),
 (29,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.8,NULL,0.058,780,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (30,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Nitrogen',0.8,NULL,0.066,650,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (31,'Gasification','Bubbling Fluidized Bed','Sand','Pressurized Hopper with screw feeder','Steam/Nitrogen (90:10)',0.8,NULL,0.058,780,111.5,NULL,NULL,NULL,NULL,3,NULL),
 (32,'Pyrolysis','Fixed bed',NULL,'Batch Mode','Nitrogen',NULL,NULL,NULL,300,100,50,NULL,NULL,NULL,4,200),
 (33,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,350,100,50,NULL,NULL,NULL,4,200),
 (34,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,400,100,50,NULL,NULL,NULL,4,200),
 (35,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,450,100,50,NULL,NULL,NULL,4,200),
 (36,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,50,NULL,NULL,NULL,4,200),
 (37,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,50,NULL,NULL,NULL,4,200),
 (38,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,550,100,50,NULL,NULL,NULL,4,200),
 (39,'Pyrolysis','Fixed bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,600,100,50,NULL,NULL,NULL,4,200),
 (40,'Pyrolysis','Fluid bed','Sand','Hopper with screw conveyors',NULL,NULL,0.014,0.019,400,NULL,NULL,NULL,2,3,5,NULL),
 (41,'Pyrolysis','Fluid bed','Sand','Hopper with screw conveyors',NULL,NULL,0.014,0.019,600,NULL,NULL,NULL,2,3,5,NULL),
 (42,'Pyrolysis','Fluid bed','Sand','Hopper with screw conveyors',NULL,NULL,0.014,0.019,400,NULL,NULL,NULL,2,3,5,NULL),
 (43,'Pyrolysis','Fluid bed','Sand','Hopper and screw feeder','Nitrogen',NULL,NULL,NULL,500,NULL,NULL,NULL,1,2,6,NULL),
 (44,'Pyrolysis','Fluid bed','Sand','Hopper and screw feeder','Nitrogen',NULL,NULL,NULL,500,NULL,NULL,NULL,1,2,6,NULL),
 (45,'Pyrolysis','Fluid bed','Sand','Hopper and screw feeder','Nitrogen',NULL,NULL,NULL,500,NULL,NULL,NULL,1,2,6,NULL),
 (46,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,400,100,300,NULL,NULL,NULL,7,100),
 (47,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,300,NULL,NULL,NULL,7,100),
 (48,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,550,100,300,NULL,NULL,NULL,7,100),
 (49,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,700,NULL,300,NULL,NULL,NULL,7,100),
 (50,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,300,NULL,NULL,NULL,7,50),
 (51,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,300,NULL,NULL,NULL,7,200),
 (52,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen ',NULL,NULL,NULL,500,100,300,NULL,NULL,NULL,7,400),
 (53,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,5,NULL,NULL,NULL,7,100),
 (54,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',100,NULL,NULL,500,NULL,100,NULL,NULL,NULL,7,100),
 (55,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,500,NULL,NULL,NULL,7,100),
 (56,'Pyrolysis','Fixed Basket in Tube Reactor',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,100,700,NULL,NULL,NULL,7,100),
 (57,'Pyrolysis','Bubbling Fluidized Bed','Sand','Gravimeter Feeder with variable speed auger','Nitrogen',0.46,0.037,NULL,480,4,66,77,0.1,NULL,8,NULL),
 (58,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,350,NULL,10,18,NULL,NULL,9,2),
 (59,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,400,NULL,10,18,NULL,NULL,9,2),
 (60,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,NULL,10,18,NULL,NULL,9,2),
 (61,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,600,NULL,10,18,NULL,NULL,9,2),
 (62,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,700,NULL,10,18,NULL,NULL,9,2),
 (63,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,350,NULL,10,18,NULL,NULL,9,2),
 (64,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,400,NULL,10,18,NULL,NULL,9,2),
 (65,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,NULL,10,18,NULL,NULL,9,2),
 (66,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,600,NULL,10,18,NULL,NULL,9,2),
 (67,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,700,NULL,10,18,NULL,NULL,9,2),
 (68,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,350,NULL,10,18,NULL,NULL,9,2),
 (69,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,400,NULL,10,18,NULL,NULL,9,2),
 (70,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,NULL,10,18,NULL,NULL,9,2),
 (71,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,600,NULL,10,18,NULL,NULL,9,2),
 (72,'Pyrolysis','Packed Bed',NULL,NULL,'Nitrogen',NULL,NULL,NULL,700,NULL,10,18,NULL,NULL,9,2),
 (73,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,300,NULL,NULL,NULL,3600,NULL,10,200),
 (74,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,400,NULL,NULL,NULL,3600,NULL,10,200),
 (75,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,NULL,NULL,NULL,3600,NULL,10,200),
 (76,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,600,NULL,NULL,NULL,3600,NULL,10,200),
 (77,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,700,NULL,NULL,NULL,3600,NULL,10,200),
 (78,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,800,NULL,NULL,NULL,3600,NULL,10,200),
 (79,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,900,NULL,NULL,NULL,3600,NULL,10,200),
 (80,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,NULL,NULL,NULL,3600,NULL,10,200),
 (81,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,NULL,NULL,NULL,3600,NULL,10,200),
 (82,'Pyrolysis','Tube Reactor with Sample Basket',NULL,NULL,'Nitrogen',NULL,NULL,NULL,500,NULL,NULL,NULL,3600,NULL,10,200);
/*!40000 ALTER TABLE `convconditions` ENABLE KEYS */;


--
-- Definition of table `experiment`
--

DROP TABLE IF EXISTS `experiment`;
CREATE TABLE `experiment` (
  `experiment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `exp_summary` text,
  `ashanal_fk` int(10) unsigned DEFAULT NULL,
  `calanal_fk` int(10) unsigned DEFAULT NULL,
  `convcond_fk` int(10) unsigned DEFAULT NULL,
  `material_fk` int(10) unsigned DEFAULT NULL,
  `physprops_fk` int(10) unsigned DEFAULT NULL,
  `prodcal_fk` int(10) unsigned DEFAULT NULL,
  `proxanal_fk` int(10) unsigned DEFAULT NULL,
  `struct_fk` int(10) unsigned DEFAULT NULL,
  `ultanal_fk` int(10) unsigned DEFAULT NULL,
  `yields_fk` int(10) unsigned DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  `ExperimentName` varchar(25) NOT NULL,
  PRIMARY KEY (`experiment_id`),
  KEY `CalAnal` (`calanal_fk`),
  KEY `ConvCond` (`convcond_fk`),
  KEY `Material` (`material_fk`),
  KEY `PhysProps` (`physprops_fk`),
  KEY `ProdCal` (`prodcal_fk`),
  KEY `ProxAnal` (`proxanal_fk`),
  KEY `Struct` (`struct_fk`),
  KEY `UltAnal` (`ultanal_fk`),
  KEY `Yields` (`yields_fk`),
  KEY `AshAnal` (`ashanal_fk`),
  KEY `FK_experiment` (`ref_fk`),
  CONSTRAINT `FK_experiment` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `experiment`
--

/*!40000 ALTER TABLE `experiment` DISABLE KEYS */;
INSERT INTO `experiment` (`experiment_id`,`exp_summary`,`ashanal_fk`,`calanal_fk`,`convcond_fk`,`material_fk`,`physprops_fk`,`prodcal_fk`,`proxanal_fk`,`struct_fk`,`ultanal_fk`,`yields_fk`,`ref_fk`,`ExperimentName`) VALUES 
 (1,'Production of bio-oil from alfalfa stem material at two stages of maturity is examined to evaluate impact of variation of cell wall polysaccharide and lignin content on pyrolysis oil yields, production efficiency, bio-oil and char quality.  More mature feedstock contained more cellulose and lignin and less ash than less-mature feedstock. Bio-oil yields and energy recovery slightly higher for more mature plants.',0,1,1,1,2,0,1,1,1,1,1,'Alfalfa Bud Pyrolysis '),
 (2,'Production of bio-oil from alfalfa stem material at two stages of maturity is examined to evaluate impact of variation of cell wall polysaccharide and lignin content on pyrolysis oil yields, production efficiency, bio-oil and char quality.  More mature feedstock contained more cellulose and lignin and less ash than less-mature feedstock. Bio-oil yields and energy recovery slightly higher for more mature plants.',0,2,2,2,1,0,2,2,2,2,1,'Alfalfa Flower Pyrolysis '),
 (3,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on almonds shells with particle sizes of 0.3-0.5 mm and heating rate in the range of 10 K/min.',0,3,3,3,3,0,3,3,3,5,2,'Almond Size1, T1'),
 (4,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on almond shells with a particle size range of 5-15 mm and a heating rate of 10 K/min. \n\n',0,4,4,4,4,0,4,4,4,6,2,'Almond Size2, T1'),
 (5,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted with almond shells with sizes of 5-30 mm at a heating rate of 10 K/min.',0,5,5,5,5,0,5,5,5,7,2,'Almond Size3, T1'),
 (6,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on almond shells with sizes in the range of 5-30 mm and a heating rate of 30 K/min.\n\n',0,6,6,6,6,0,6,6,6,8,2,'Almond Size3, T2'),
 (7,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on almond shells with sizes of 5-15 mm and at a heating rate of 30 K/min.\n\n',0,7,7,7,7,0,7,7,7,9,2,'Almond Size2, T2'),
 (8,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment is conducted with particle sizes of 0.3 to 0.5 and at a heating rate of 30 K/min.',0,8,8,8,8,0,8,8,8,10,2,'Almond Size1, T2'),
 (9,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiments was conducted with grape refuse with particle sizes of 1-10 mm and a heating rate of 10 K/min.\n\n',0,9,9,9,9,0,9,9,9,11,2,'Grape Size1, T1'),
 (10,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment is conducted on grape refuse with particle sizes in the range of 0.3-0.5 mm and a heating rate of 10 K/min.\n\n',0,10,10,10,10,0,10,10,10,12,2,'Grape Size2, T1'),
 (11,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted with grape refuse with particle size range of 1-10 mm and at a heating rate of 30 K/min.\n',0,11,11,11,11,0,11,11,11,13,2,'Grape Size1, T2'),
 (12,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on grape refuse in the particle size range of 0.3-0.5 mm and a heating rate of 30 K/min.',0,12,12,12,12,0,12,12,12,14,2,'Grape Size2, T2'),
 (13,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on olive stone with particle size range of 0.5-2.0 mm and a heating rate of 10 K/min.',0,13,13,13,13,0,13,13,13,15,2,'OliveSize1T1'),
 (14,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on olive stones with particle size range of 0.3-0.5 mm and a heating rate of 10 K/min.\n\n',0,14,0,14,14,0,14,14,14,0,2,'OliveSize2T1'),
 (15,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment is conducted with olive stone in the size range of 0.5-2.0 mm and with a heating rate of 30 K/min.',0,15,0,15,15,0,0,15,15,0,2,'OliveSize1T2'),
 (16,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on olive stones in the size range of 0.3-0.5 mm and with a heating rate of 30 K/min.',0,16,14,16,16,0,15,16,16,16,2,'OliveSize2T2'),
 (17,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted with a wheat pellet 5 mm OD and 100 mm L with a heating rate of 10 K/min.\n\n',0,17,15,17,17,0,16,17,17,17,2,'WheatSize1T1'),
 (18,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted with wheat pellet 5 mm OD and 5 mm L and a heating rate of 10 K/min.',0,18,16,18,18,0,17,18,18,18,2,'WheatSize2T1'),
 (19,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted with ground wheat straw with size range of 0.3-0.5 and a heating rate of 10 K/min.',0,19,17,19,19,0,18,19,19,19,2,'WheatSize3T1'),
 (20,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on a wheat pellet 5 mm OD and 100 mm L with a heating rate of 30 K/min.',0,20,19,20,20,0,19,20,20,20,2,'WheatSize1T2'),
 (21,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on a wheat straw pellet 5 mm OD and 5 mm L at a heating rate of 30 K/min.\n\n',0,21,20,21,21,0,20,21,21,21,2,'WheatSize2T2'),
 (22,'Conventional pyrolysis experiments were conducted in a packed bed reactor at 5, 10, 15, and 30 K/min to a final temperature of 923 K (650 ºC). Temperature profiles, conversion times, product yields, and gas composition have been analyzed to investigate the influence of the biomass composition and the operating conditions on the process. Large differences were noted in the outputs when the heating rate was increased to 30 K/min. This experiment was conducted on ground wheat straw in the size range of 0.3-0.5 mm and a heating rate of 30 K/min.',0,22,21,22,22,0,21,22,22,22,2,'WheatSize3T2'),
 (23,'Biomass samples, including pine wood chips, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with pine wood chips at gasifier temperature of 650 C.',0,23,22,0,23,0,22,0,23,23,3,'WoodChipsT1'),
 (24,'Biomass samples, including pine wood chips, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with wood chips at temperature of 780 C.',0,24,23,23,24,0,23,0,24,24,3,'WoodChipsT2'),
 (25,'Biomass samples, including thistle, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted on thistle at 650 C.',0,25,24,24,0,0,24,0,25,25,3,'ThistleT1'),
 (26,'Biomass samples, including thistle, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with thistle at 780 C.',0,26,25,25,0,0,25,0,26,26,3,'ThistleT2'),
 (27,'Biomass samples, including thistle, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction.  This experiment was conducted with pine sawdust with mean particle diameter of around 500 microns at a temperature of around 750 C and a steam to biomass ratio of around 0.5.',0,27,26,26,25,0,26,0,27,27,3,'PineDustS/B1T1'),
 (28,'Biomass samples have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with pine sawdust with a mean diameter of around 500 microns, steam to biomass ratio of 2.5, and a temperature of 750 C.',0,28,27,27,26,0,27,0,28,28,3,'PineDustS/B2T1'),
 (29,'Biomass samples, including pine sawdust, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with sawdust with a mean diameter of around 500 microns, steam to biomass ration of 0.8 at a temperature of 650 C.',0,29,28,28,27,0,28,0,29,29,3,'PineDustS/B3T1'),
 (30,'Biomass samples, including pine sawdust, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with pine sawdust with a mean particle size of around 500 microns, steam to biomass ratio of 0.8, and a temperature of 780 C.\n\n',0,30,29,29,28,0,29,0,30,30,3,'PineDustS/B3T2'),
 (31,'Biomass samples, including wheat straw, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with wheat straw greater than 5 mm in size, steam to biomass ratio of 0.8, and a temperature of 650 C.',0,31,30,30,29,0,30,0,31,31,3,'StrawT1'),
 (32,'Biomass samples, including wheat straw, have been gasified with steam in a fluidized bed reactor. The gas, char, tar yields and the composition and heating value of the gas produced at temperatures were determined between 650-780 ºC. The product distribution varies with the biomass used and the gasification temperature. These differences decrease when the temperature increases to 780 ºC at which point a similar gas composition is obtained for all biomass types tested by achieving equilibrium in the water-gas shift reaction. This experiment was conducted with wheat straw greater than 5 mm long, steam to biomass ratio of 0.8, and a temperature of 780 C.',0,32,31,31,30,0,31,0,32,32,3,'StrawT2'),
 (33,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 ºC and -5 ºC. This experiment shows the product distribution at a temperature of 300 C.',0,33,32,32,31,0,32,0,33,33,4,'BagasseTemp1'),
 (34,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 ºC and -5 ºC. This experiment shows the product distribution at a temperature of 350 C.',0,34,33,33,32,0,33,0,34,34,4,'BagasseTemp2'),
 (35,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 ºC and -5 ºC. In this experiment, the products yields were collected at a temperature of 400 C',0,35,34,34,33,0,34,0,35,35,4,'BagasseTemp3'),
 (36,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 ºC and -5 ºC. In this experiment, the product yields are determined at a temperature of 450 C.\n\n',0,36,35,35,34,0,35,0,36,36,4,'BagasseTemp4'),
 (37,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 C and -5 C. This experiment determines the product yield at a temperature of 500 C. The chemical composition of the oil collected from the 60 degree C condenser is also presented.',0,37,36,36,35,0,36,0,37,37,4,'BagasseCondenser60Temp5'),
 (38,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 ºC and -5 ºC. This experiment presents yield data determined at 500 C and oil condenser at -5 ºC.\n',0,38,37,37,36,0,37,0,38,38,4,'BagasseCondenser-5Temp5'),
 (39,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 ºC and -5 ºC. This experiment determines the yield product distribution generated at 550 C.\n	\n',0,39,38,38,37,0,38,0,39,39,4,'BagasseTemp6'),
 (40,'Pyrolysis of bagasse was investigated with batch feeding of a fixed bed reactor. Experiments were conducted at temperatures ranging from 300-600 ºC. Bio-oil was collected and key properties were compared from two condensers at temperatures of 60 ºC and -5 ºC.  This experiment presents the product distribution generated at 600 C.',0,40,39,39,38,0,39,0,40,40,4,'BagasseTemp7'),
 (41,'Washed and unwashed samples of rice straw were investigated in a fluidized bed bench scale fast pyrolyzer equipped with a char removal system. Impact of temper-ature in the range of 400 °C to 600 °C on the production of bio-oil and the efficiency of the char removal system were investigated. The char removal system and the pretreatment by washing were noted to effectively reduce the content of alkali metals in the bio-oil. This experiment presents the result of the products of unwashed rice straw at a temperature of 400 C.',1,41,40,40,39,0,40,23,41,41,5,'UnwashedRiceStrawT1'),
 (42,'Washed and unwashed samples of rice straw were investigated in a fluidized bed bench scale fast pyrolyzer equipped with a char removal system. Impact of temper-ature in the range of 400 °C to 600 °C on the production of bio-oil and the efficiency of the char removal system were investigated. The char removal system and the pretreatment by washing were noted to effectively reduce the content of alkali metals in the bio-oil. This experiment shows the pyrolysis product distribution from unwashed rice straw at a temperature of 600 C.',2,42,41,41,40,0,41,24,42,42,5,'UnwashedRiceStrawT2'),
 (43,'Washed and unwashed samples of rice straw were investigated in a fluidized bed bench scale fast pyrolyzer equipped with a char removal system. Impact of temperature in the range of 400 °C to 600 °C on the production of bio-oil and the efficiency of the char removal system were investigated. The char removal system and the pretreatment by washing were noted to effectively reduce the content of alkali metals in the bio-oil.  This experiment presents pyrolysis product data on rice straw that has been soaked in water and then dried to lower alkali metal content.',3,43,42,42,41,0,42,25,43,43,5,'WashedRiceStrawT1'),
 (44,'Oreganum stalks were pyrolyzed at 500 °C in a bench scale, fluidized bed reactor. Yields of char, liquid, and gas were quantified. Liquids were produced in two separate phases: aqueous and oil. Oils were fractionated by water extraction into two fractions: water solubles and water unsolubles. Aqueous phase and water soluble fractions were analyzed by gas chromatography-mass spectrometry and high performance liquid chromatography. Water content and elemental analyses of oils were conducted. Compositions of gas and char products relative to fuel applications were determined. ',0,0,43,43,42,0,43,26,44,44,6,'Oreganum Stalk Pyrolysis'),
 (45,'Corncobs were pyrolyzed at 500 °C in a bench scale, fluidized bed reactor. Yields of char, liquid, and gas were quantified. Liquids were produced in two separate phases: aqueous and oil. Oils were fractionated by water extraction into two fractions: water solubles and water unsolubles. Aqueous phase and water soluble fractions were analyzed by gas chromatography-mass spectrometry and high performance liquid chromatography. Water content and elemental analyses of oils were conducted. Compositions of gas and char products relative to fuel applications were determined. ',0,0,44,44,43,0,44,27,45,45,6,'CorncobPyrolysis'),
 (46,'Wheat straw was pyrolyzed at 500 °C in a bench scale, fluidized bed reactor. Yields of char, liquid, and gas were quantified. Liquids were produced in two separate phases: aqueous and oil. Oils were fractionated by water extraction into two fractions: water solubles and water unsolubles. Aqueous phase and water soluble fractions were analyzed by gas chromatography-mass spectrometry and high performance liquid chromatography. Water content and elemental analyses of oils were conducted. Compositions of gas and char products relative to fuel applications were determined. ',0,0,45,45,44,0,45,28,46,46,6,'WheatStrawPyrolysis'),
 (47,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 400 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 300 ºC.',0,44,46,46,45,0,46,29,47,0,7,'PistachioShellT1'),
 (48,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 300  ºC/min.',0,45,47,47,46,0,47,30,48,47,7,'PistachioShellT2SG1'),
 (49,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 550 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 300  ºC/min.\n\n',0,46,48,48,47,0,48,31,49,48,7,'PistachioShellT3SG1'),
 (50,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 700 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 300  ºC/min.',0,47,49,49,48,0,49,32,50,49,7,'PistachioShellT4SG1'),
 (51,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 50 cm3/min and a heating rate of 300  ºC/min.\n\n',0,48,50,50,49,0,50,33,51,0,7,'PistachioShellT2SG2'),
 (52,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 200 cm3/min and a heating rate of 300  ºC/min.',0,49,51,51,50,0,51,34,52,51,7,'PistachioShellT2SG3'),
 (53,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 400 cm3/min and a heating rate of 300 ºC/min.',0,50,52,52,51,0,52,35,53,52,7,'PistachioShellT2SG4'),
 (54,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 5 ºC/min.',0,51,53,53,52,0,53,36,54,53,7,'PistachioShellT2SG1HR1'),
 (55,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 100 ºC/min.',0,52,54,54,0,0,54,37,55,54,7,'PistachioShellT2SG1HR2'),
 (56,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 500 ºC/min.',0,53,55,55,53,0,55,38,56,55,7,'PistachioShellT2SG1HR3'),
 (57,'Pyrolysis of pistachio shell was conducted under varying temperatures, temperature heat and sweep gas rates in a tubular reactor. Column chromatography was applied to the produced bio-oil and its subfractions were characterized by elemental analysis using FT-IR and 1H-NMR. This experiment presents data collected at a temperature of 500 ºC with a sweep gas rate of 100 cm3/min and a heating rate of 700 ºC/min.\n\n',0,54,56,56,54,0,56,39,57,56,7,'PistachioShellT2SG1HR4'),
 (58,'Bio-oil yields and energy conversion efficiencies for bench-scale fluidized-bed pyrolysis of Cave-in-Rock cultivar switchgrass investigated. Study indicates char yield would be sufficient to provide all the energy for the pyrolysis process. Mass and energy balances calculated.  Switchgrass is pyrolyzed at 480 C and physical and thermal properties of pyrolysis oil is analyzed from the condensers.',0,55,57,57,55,0,57,0,58,57,8,'SwitchgrassPyrolysisCon'),
 (59,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of cardboard were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700  ºC with a slow heating rate. This experiment reports data collected at 350 C and a heating rate of 10-18 ºC/min.',0,57,58,58,56,0,0,0,0,59,9,'CardboardPyrolysisT1'),
 (60,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of cardboard were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700  ºC with a slow heating rate. This experiment reports data collected at 400 ºC and a heating rate of 10-18 ºC/min.',0,58,59,59,57,0,0,0,0,60,9,'CardboardPyrolysisT2'),
 (61,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of cardboard were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700  ºC with a slow heating rate. This experiment reports data collected at 500 ºC and a heating rate of 10-18 ºC/min.',0,59,60,60,58,0,0,0,0,61,9,'CardboardPyrolysisT3'),
 (62,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of cardboard were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment reports data collected at 600 ºC and a heating rate of 10-18 ºC/min.',0,0,61,61,59,0,0,0,0,62,9,'CardboardPyrolysisT4'),
 (63,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of cardboard were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment reports data collected at 700 ºC and a heating rate of 10-18 ºC/min.',0,60,62,62,60,0,0,0,0,63,9,'CardboardPyrolysisT5'),
 (64,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of waste wood were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data on waste wood at a temperature of 350 ºC with a heating rate of 10-18 ºC/min.',0,56,63,63,61,0,0,0,0,64,9,'WasteWoodPyroT1'),
 (65,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of waste wood were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data on waste wood at a temperature of 400 ºC with a heating rate of 10-18 ºC/min.',0,61,64,64,62,0,0,0,0,65,9,'WasteWoodPyroT2'),
 (66,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of waste wood were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data on waste wood at a temperature of 500 ºC with a heating rate of 10-18 ºC/min.',0,62,65,65,63,0,0,0,0,66,9,'WasteWoodPyroT3'),
 (67,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of waste wood were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data on waste wood at a temperature of 600 ºC with a heating rate of 10-18 ºC/min.',0,63,66,66,64,0,0,0,0,67,9,'WasteWoodPyroT4'),
 (68,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of waste wood were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data on waste wood at a temperature of 700 ºC with a heating rate of 10-18 ºC/min.',0,64,67,67,65,0,0,0,0,68,9,'WasteWoodPyroT5'),
 (69,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of textile residues were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data at a temperature of 350 ºC and a heating rate of 10-18 ºC.',0,65,68,0,66,0,0,0,0,0,9,'TextileResidueT1'),
 (70,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of textile residues were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data at a temperature of 400 ºC and a heating rate of 10-18 ºC/min.',0,66,69,68,67,0,0,0,0,70,9,'TextileResidueT2'),
 (71,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of textile residues were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data at a temperature of 500 ºC and a heating rate of 10-18 ºC/min.',0,67,70,69,68,0,0,0,0,71,9,'TextileResidueT3'),
 (72,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of textile residues were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data at a temperature of 600 ºC and a heating rate of 10-18 ºC/min.\n\n',0,68,71,70,69,0,0,0,0,72,9,'TextileResidueT4'),
 (73,'The main products form slow pyrolysis of segregated waste materials were characterized for mass yield, energy content, elemental composition and chemical compounds. About 200 g of textile residues were pyrolyzed in a small packed bed reactor at a final temperature ranging from 350 to 700 ºC with a slow heating rate. This experiment collects data at a temperature of 700 ºC and a heating rate of 10-18 ºC/min.',0,69,72,71,70,0,0,0,0,73,9,'TextileResidueT5'),
 (74,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 300 ºC with wood in the particle size range of 0.62-1.0mm in diameter.',0,0,73,72,71,0,0,0,0,74,10,'HolmOakWood300CSize1mm'),
 (75,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 400 ºC with wood in the particle size range of 0.62-1.0mm in diameter.',0,0,74,73,72,0,0,0,0,75,10,'HolmOakWood400CSize1mm'),
 (76,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 500 ºC with wood in the particle size range of 0.62-1.0mm in diameter.',0,0,75,74,73,0,0,0,0,76,10,'HolmOakWood500CSize1mm'),
 (77,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 600 ºC with wood in the particle size range of 0.62-1.0mm in diameter.',0,0,76,75,74,0,0,0,0,79,10,'HolmOakWood600CSize1mm'),
 (78,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 700 ºC with wood in the particle size range of 0.62-1.0mm in diameter.',0,0,77,76,75,0,0,0,0,80,10,'HolmOakWood700CSize1mm'),
 (79,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 800 ºC with wood in the particle size range of 0.62-1.0mm in diameter.',0,0,78,77,76,0,0,0,0,81,10,'HolmOakWood800CSize1mm'),
 (80,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas composi-tions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 900 ºC with wood in the particle size range of 0.62-1.0mm in diameter.',0,0,79,78,77,0,0,0,0,82,10,'HolmOakWood900CSize1mm'),
 (81,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 500 ºC with wood in the particle size range of 0.40-0.63mm in diameter.',0,0,80,79,78,0,0,0,0,83,10,'HolmOakWood500CSize0.6mm'),
 (82,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 500 ºC with wood in the particle size range of 1.0-1.63mm in diameter.',0,0,81,80,79,0,0,0,0,84,10,'HolmOakWood500CSize1.6mm'),
 (83,'Pyrolysis of holm-oak wood was investigated in a cylindrical reactor with a wire mesh basket to contain the sample. Experiments were conducted at temperatures ranging from 300-900 ºC and with particle sizes 0.4 to 2 mm. The product yields, gas compositions, and charcoal compositions were reported and the rate constants for the production of gaseous components were determined. This experiment collects pyrolysis data at 500 ºC with wood in the particle size range of 1.6-2mm in diameter.',0,0,82,81,80,0,0,0,0,85,10,'HolmOakWood500CSize2mm');
/*!40000 ALTER TABLE `experiment` ENABLE KEYS */;


--
-- Definition of table `gascomp`
--

DROP TABLE IF EXISTS `gascomp`;
CREATE TABLE `gascomp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `H2` double DEFAULT NULL,
  `CO` double DEFAULT NULL,
  `CO2` double DEFAULT NULL,
  `CH4` double DEFAULT NULL,
  `C2H2` double DEFAULT NULL,
  `C2H4` double DEFAULT NULL,
  `C2H6` double DEFAULT NULL,
  `N2` double DEFAULT NULL,
  `GCV` double DEFAULT NULL,
  `Tar` double DEFAULT NULL,
  `misc_fk` int(10) unsigned DEFAULT NULL,
  `experiment_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `yds_ind_gcomp` (`id`),
  KEY `GasComps_Misc` (`misc_fk`),
  CONSTRAINT `yds_fk_gcomp` FOREIGN KEY (`id`) REFERENCES `yields` (`gasComp_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gascomp`
--

/*!40000 ALTER TABLE `gascomp` DISABLE KEYS */;
INSERT INTO `gascomp` (`id`,`H2`,`CO`,`CO2`,`CH4`,`C2H2`,`C2H4`,`C2H6`,`N2`,`GCV`,`Tar`,`misc_fk`,`experiment_id`) VALUES 
 (1,NULL,24.7,64.9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3),
 (2,NULL,32.8,49.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8),
 (3,NULL,17.8,68.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (4,NULL,19.1,58.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12),
 (5,NULL,25,53.9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16),
 (6,NULL,23.2,66.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,19),
 (7,NULL,25.6,54.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,22),
 (8,38,22,11,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,23),
 (9,50,17,15,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,24),
 (10,40,24,22,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,25),
 (11,52,18,18,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,26),
 (12,50,48,11,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,29),
 (13,54,15,41,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,30),
 (14,36,32,17,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,31),
 (15,47.5,22,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32),
 (16,NULL,29,65,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,41),
 (17,NULL,31,54,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,43),
 (18,5.1,57.6,29.5,7.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,58),
 (19,13.4,36.6,32.4,15.3,NULL,NULL,NULL,NULL,13.3,NULL,NULL,63),
 (20,7,30.5,44.7,14.7,NULL,NULL,NULL,NULL,12.6,NULL,NULL,68);
/*!40000 ALTER TABLE `gascomp` ENABLE KEYS */;


--
-- Definition of table `gascomps_misc`
--

DROP TABLE IF EXISTS `gascomps_misc`;
CREATE TABLE `gascomps_misc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `component` varchar(45) DEFAULT NULL,
  `relativeContent` double DEFAULT NULL,
  `detected` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gasMisc_fk` (`id`),
  CONSTRAINT `gasMisc_fk` FOREIGN KEY (`id`) REFERENCES `gascomp` (`misc_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gascomps_misc`
--

/*!40000 ALTER TABLE `gascomps_misc` DISABLE KEYS */;
/*!40000 ALTER TABLE `gascomps_misc` ENABLE KEYS */;


--
-- Definition of table `liquidcomp`
--

DROP TABLE IF EXISTS `liquidcomp`;
CREATE TABLE `liquidcomp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aqueous` double DEFAULT NULL,
  `oil` double DEFAULT NULL,
  `water` double DEFAULT NULL,
  `oil_ult_fk` int(10) unsigned DEFAULT NULL,
  `oil_phys_fk` int(10) unsigned DEFAULT NULL,
  `oilcomp_fk` int(10) unsigned DEFAULT NULL,
  `oil_misc_fk` int(10) unsigned DEFAULT NULL,
  `experiment_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `yds_ind_liqcomp` (`id`),
  KEY `liq_oil_ult` (`oil_ult_fk`),
  KEY `liq_oil_phys` (`oil_phys_fk`),
  KEY `liq_oil_oilComp` (`oilcomp_fk`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `liquidcomp`
--

/*!40000 ALTER TABLE `liquidcomp` DISABLE KEYS */;
INSERT INTO `liquidcomp` (`id`,`aqueous`,`oil`,`water`,`oil_ult_fk`,`oil_phys_fk`,`oilcomp_fk`,`oil_misc_fk`,`experiment_id`) VALUES 
 (1,NULL,45,NULL,1,1,NULL,NULL,1),
 (2,NULL,53,NULL,2,2,NULL,NULL,2),
 (3,NULL,66.13,NULL,NULL,3,1,NULL,37),
 (4,NULL,NULL,NULL,NULL,4,NULL,NULL,38),
 (5,NULL,53,NULL,NULL,5,NULL,NULL,43),
 (6,6,39,NULL,3,NULL,NULL,NULL,44),
 (7,6,41,NULL,4,NULL,NULL,NULL,45),
 (8,6,35,NULL,5,NULL,NULL,NULL,46),
 (9,NULL,27,NULL,6,NULL,NULL,NULL,48),
 (10,NULL,20.5,NULL,NULL,NULL,NULL,NULL,49),
 (11,NULL,22.5,NULL,NULL,NULL,NULL,NULL,50),
 (12,NULL,23.5,NULL,NULL,NULL,NULL,NULL,51),
 (13,NULL,27,NULL,NULL,NULL,NULL,NULL,52),
 (14,NULL,24,NULL,NULL,NULL,NULL,NULL,53),
 (15,NULL,21,NULL,NULL,NULL,NULL,NULL,54),
 (16,NULL,22.5,NULL,NULL,NULL,NULL,NULL,55),
 (17,NULL,27,NULL,NULL,NULL,NULL,NULL,56),
 (18,NULL,24,NULL,NULL,NULL,NULL,NULL,57),
 (19,NULL,61,NULL,NULL,NULL,NULL,NULL,58),
 (20,83.9,16.1,NULL,NULL,6,2,NULL,61),
 (21,NULL,NULL,NULL,NULL,7,3,NULL,62),
 (22,87.8,12.2,NULL,NULL,8,NULL,NULL,63),
 (23,74.2,25.8,NULL,NULL,9,NULL,NULL,64),
 (24,NULL,NULL,NULL,NULL,10,NULL,NULL,65),
 (25,NULL,NULL,NULL,NULL,NULL,4,NULL,64),
 (26,78.1,21.9,NULL,NULL,11,NULL,NULL,66),
 (27,89.2,10.2,NULL,NULL,NULL,5,NULL,68),
 (28,72.8,27.2,NULL,NULL,NULL,NULL,NULL,69),
 (29,73.6,26.4,NULL,NULL,NULL,NULL,NULL,71),
 (30,81.2,18.8,NULL,NULL,NULL,NULL,NULL,73);
/*!40000 ALTER TABLE `liquidcomp` ENABLE KEYS */;


--
-- Definition of table `material`
--

DROP TABLE IF EXISTS `material`;
CREATE TABLE `material` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `class` varchar(50) DEFAULT NULL,
  `source` varchar(200) DEFAULT NULL,
  `handlingHistory` varchar(300) DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_mat` (`id`),
  KEY `ref_ind_mat` (`ref_fk`),
  CONSTRAINT `exp_fk_mat` FOREIGN KEY (`id`) REFERENCES `experiment` (`material_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_mat` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `material`
--

/*!40000 ALTER TABLE `material` DISABLE KEYS */;
INSERT INTO `material` (`id`,`name`,`class`,`source`,`handlingHistory`,`ref_fk`) VALUES 
 (1,'Alfalfa ','','Collected at early bud stage from breeding nurseries located at Rosemount and Becker, MN','Dried at 60 C and hand separated into leaf and stem fractions ',1),
 (2,'Alfalfa ','','Collected from breeding nurseries located at Rosemount and Becker, MN','Driec at 60 C and hand separated into leaf and steam fractions ',1),
 (3,'Almond Shells','','','',2),
 (4,'Almond Shells','','','',2),
 (5,'Almond Shells','','','',2),
 (6,'Almond Shells','','','',2),
 (7,'Almond Shells','','','',2),
 (8,'Almond Shells','','','',2),
 (9,'Grape Refuse','','','',2),
 (10,'Grape Refuse','','','',2),
 (11,'Grape Refuse','','','',2),
 (12,'Grape Refuse','','','',2),
 (13,'Olive Stone','','','',2),
 (14,'Olive Stone','','','',2),
 (15,'Olive Stone','','','',2),
 (16,'Olive Stone','','','',2),
 (17,'Wheat Straw','','','',2),
 (18,'Wheat Straw','','','',2),
 (19,'Wheat Straw','','','',2),
 (20,'Wheat Straw','','','',2),
 (21,'Wheat Straw','','','',2),
 (22,'Wheat Straw ','','','',2),
 (23,'Wood Chips','','','',3),
 (24,'Thistle','','C. Cardunculus variety\n\n','',3),
 (25,'Thistle','','C. Cardunculus variety','',3),
 (26,'Pine Sawdust','','','',3),
 (27,'Pine Sawdust','','','',3),
 (28,'Pine Sawdust','','','',3),
 (29,'Pine Sawdust','','','',3),
 (30,'Wheat Straw','','','',3),
 (31,'Wheat Straw','','','',3),
 (32,'Bagassee','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically-crushed',4),
 (33,'Bagasse','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically crushed',4),
 (34,'Bagasse','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically-crushed',4),
 (35,'Bagasse','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically-crushed',4),
 (36,'Bagasse','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically-crushed',4),
 (37,'Bagasse','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically-crushed',4),
 (38,'Bagasse','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically-crushed',4),
 (39,'Bagasse','','By-product of Bangladesh sugar market','Dried in sunlight and mechanically-crushed',4),
 (40,'Rice Straw','','Province in Korea','Rice straw was cut into rectangular pieces with a diameter of ~ 5 mm. Some samples were treated by soaking in distilled water for 2 days and then dried in an oven at 60 °C for a day.',5),
 (41,'Rice Straw','','Province in Korea','Rice straw was cut into rectangular pieces with a diameter of ~ 5 mm. Some samples were treated by soaking in distilled water for 2 days and then dried in an oven at 60 °C for a day.',5),
 (42,'Rice Straw','','Province in Korea','Rice straw was cut into rectangular pieces with a diameter of ~ 5 mm. Some samples were treated by soaking in distilled water for 2 days and then dried in an oven at 60 °C for a day.',5),
 (43,'Oreganum Stalks','','','Crushed to particle size less than 1 mm',6),
 (44,'Corncob','',NULL,'Crushed to particle size less than 1 mm',6),
 (45,'Wheat Straw','','','Crushed to particle size less than 1 mm.',6),
 (46,'Pistachio Shell','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size',7),
 (47,'Pistachio Shells','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.',7),
 (48,'Pistachio Shells','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.',7),
 (49,'Pistachio Shells','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.',7),
 (50,'Pistachio Shell','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.',7),
 (51,'Pistachio Shell','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.\n\n','Samples were air dried, milled, and sieved to uniform size.',7),
 (52,'Pistachio Shells','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.',7),
 (53,'Pistachio Shells','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.\n\n',7),
 (54,'Pistachio Shell','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.',7),
 (55,'Pistachio Shells','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.','Samples were air dried, milled, and sieved to uniform size.',7),
 (56,'Pistachio Shells','','The pistachio shells investigated were taken from some factories around Gaziantep located in Southeastern Anatola.\n\n','Samples were air dried, milled, and sieved to uniform size.\n\n',7),
 (57,'Switchgrass','','Cave-in-Rock cultivar switchgrass form USDA Agricultural Research Service Pasture Systems and Watershed Management Research Unit at University Park, PA','',8),
 (58,'Cardboard','','Collected from Sheffield University (UK) offices\n\n','Cut into 20mm squares\n\n',9),
 (59,'Cardboard','','Collected from Sheffield University (UK) offices','Cut into 20mm squares',9),
 (60,'Cardboard','','Collected from Sheffield University (UK) offices.\n\n','Cut into 20mm squares\n\n',9),
 (61,'Cardboard','','Collected from Sheffield University (UK) offices','Cut into 20mm squares',9),
 (62,'Cardboard','','Collected from Sheffield University (UK) offices\n\n','Cut into 20mm squares\n\n',9),
 (63,'Waste Wood','','Pine, along with oak and birch, collected from a local (Sheffield, UK) workshop','Cut into 20mm squares',9),
 (64,'Waste Wood','','Pine, along with oak and birch, collected from a local (Sheffield, UK) workshop\n','Cut into 20mm squares',9),
 (65,'Waste Wood','','Pine, along with oak and birch, collected from a local (Sheffield, UK) workshop\n','Cut into 20mm squares',9),
 (66,'Waste wood','','Pine, along with oak and birch, collected from a local (Sheffield, UK) workshop\n','cut into 20mm squares',9),
 (67,'Waste Wood','','Pine, along with oak and birch, collected from a local (Sheffield, UK) workshop','Cut into 20mm squares',9),
 (68,'Textile Residues','','Collected from a civic amenity site near Sheffield University (UK) offices, containing mostly cotton with small amount (5%) polyester','Cut into 30mm by 50mm squares\n\n',9),
 (69,'Textile Residue','','Collected from a civic amenity site near Sheffield University (UK) offices, containing mostly cotton with small amount (5%) polyester.','Cut into 30mm by 50mm squares',9),
 (70,'Textile Residue','','Collected from a civic amenity site near Sheffield University (UK) offices, containing mostly cotton with small amount (5%) polyester','Cut into 30mm by 50mm squares\n\n',9),
 (71,'Textile Residue','','Collected from a civic amenity site near Sheffield University (UK) offices, containing mostly cotton with small amount (5%) polyester','Cut into 30mm by 50mm squares',9),
 (72,'Holm Oak Wood','','','',10),
 (73,'Holm-Oak Wood','','','',10),
 (74,'Holm-Oak Wood','','','',10),
 (75,'Holm-Oak Wood','','','',10),
 (76,'Holm-Oak Wood','','','',10),
 (77,'Holm-Oak Wood','','','',10),
 (78,'Holm-Oak Wood','','','',10),
 (79,'Holm_Oak Wood','','','',10),
 (80,'Holm-Oak Wood','','','',10),
 (81,'Holm-oak Wood','','','',10);
/*!40000 ALTER TABLE `material` ENABLE KEYS */;


--
-- Definition of table `oil_ultanal`
--

DROP TABLE IF EXISTS `oil_ultanal`;
CREATE TABLE `oil_ultanal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `C` double DEFAULT NULL,
  `H` double DEFAULT NULL,
  `N` double DEFAULT NULL,
  `O` double DEFAULT NULL,
  `O_calc` tinyint(1) DEFAULT NULL,
  `Cl` double DEFAULT NULL,
  `S` double DEFAULT NULL,
  `H_C` double DEFAULT NULL,
  `H_C_calc` tinyint(1) DEFAULT NULL,
  `O_C` double DEFAULT NULL,
  `O_C_calc` tinyint(1) DEFAULT NULL,
  `ash` double DEFAULT NULL,
  `water` double DEFAULT NULL,
  `waterMethod` varchar(30) DEFAULT NULL,
  `experiment_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `liqComp_ind_oilUlt` (`id`),
  CONSTRAINT `liqComp_fk_oilUlt` FOREIGN KEY (`id`) REFERENCES `liquidcomp` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `oil_ultanal`
--

/*!40000 ALTER TABLE `oil_ultanal` DISABLE KEYS */;
INSERT INTO `oil_ultanal` (`id`,`C`,`H`,`N`,`O`,`O_calc`,`Cl`,`S`,`H_C`,`H_C_calc`,`O_C`,`O_C_calc`,`ash`,`water`,`waterMethod`,`experiment_id`) VALUES 
 (1,53.76,8.45,4.58,32.66,0,0.00025,0.053,6.36,0,1.65,0,0.282,21.09,'Fischer',1),
 (2,53.99,7.89,3.745,32.66,0,0.000242,0.053,6.84,0,1.65,0,0.282,21.09,'Fischer',2),
 (3,53.7,5.78,2.64,37.57,0,NULL,0.44,NULL,1,NULL,1,NULL,6.18,NULL,44),
 (4,45.01,8.48,1.1,45.26,0,NULL,0.15,NULL,1,NULL,1,NULL,14.32,NULL,45),
 (5,48.34,6.16,1.25,43.99,0,NULL,0.27,NULL,1,NULL,1,NULL,4.68,NULL,46),
 (6,67.35,8.36,0.59,23.7,0,NULL,NULL,NULL,1,NULL,1,NULL,NULL,NULL,48),
 (8,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,NULL,NULL,4);
/*!40000 ALTER TABLE `oil_ultanal` ENABLE KEYS */;


--
-- Definition of table `oilcomponents`
--

DROP TABLE IF EXISTS `oilcomponents`;
CREATE TABLE `oilcomponents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `aliphatic` double DEFAULT NULL,
  `aromatic` double DEFAULT NULL,
  `polar` double DEFAULT NULL,
  `misc_fk` int(10) unsigned DEFAULT NULL,
  `experiment_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `liqComp_ind_oilComp` (`id`),
  KEY `OilComps_Misc` (`misc_fk`),
  CONSTRAINT `liqComp_fk_oilComp` FOREIGN KEY (`id`) REFERENCES `liquidcomp` (`oilcomp_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `oilcomponents`
--

/*!40000 ALTER TABLE `oilcomponents` DISABLE KEYS */;
INSERT INTO `oilcomponents` (`id`,`aliphatic`,`aromatic`,`polar`,`misc_fk`,`experiment_id`) VALUES 
 (1,NULL,NULL,NULL,2,37),
 (2,NULL,NULL,NULL,4,61),
 (3,NULL,NULL,NULL,5,62),
 (4,NULL,NULL,NULL,7,64),
 (5,NULL,NULL,NULL,8,68),
 (6,NULL,NULL,NULL,NULL,95);
/*!40000 ALTER TABLE `oilcomponents` ENABLE KEYS */;


--
-- Definition of table `oilcomps_misc`
--

DROP TABLE IF EXISTS `oilcomps_misc`;
CREATE TABLE `oilcomps_misc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(45) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `experiment_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oilMisc_fk` (`id`),
  CONSTRAINT `oilMisc_fk` FOREIGN KEY (`id`) REFERENCES `oilcomponents` (`misc_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `oilcomps_misc`
--

/*!40000 ALTER TABLE `oilcomps_misc` DISABLE KEYS */;
INSERT INTO `oilcomps_misc` (`id`,`category`,`amount`,`experiment_id`) VALUES 
 (1,'Pyrolytic Lignin',3.51,37),
 (2,'Pyrolytic Lignin',1.25,38),
 (3,'Molecular Weight M=60',20.4,59),
 (4,'Molecular Weight M=60',19,61),
 (5,'Molecular Weight M=60',13.5,63),
 (6,'Molecular Weight M=60',28.1,64),
 (7,'Molecular Weight M=60',29,66),
 (8,'Molecular Weight M=60',20.1,69),
 (9,'Molecular Weight M=60',14.3,71),
 (10,'Molecular Weight M=60',9.1,73);
/*!40000 ALTER TABLE `oilcomps_misc` ENABLE KEYS */;


--
-- Definition of table `oilphysprops`
--

DROP TABLE IF EXISTS `oilphysprops`;
CREATE TABLE `oilphysprops` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `density` double DEFAULT NULL,
  `viscosity` double DEFAULT NULL,
  `viscosity_temp` double DEFAULT NULL,
  `flashPoint` double DEFAULT NULL,
  `pourPoint` double DEFAULT NULL,
  `pH` double DEFAULT NULL,
  `HHV` double DEFAULT NULL,
  `HeatOfCombustion` double DEFAULT NULL,
  `WaterContent` double DEFAULT NULL,
  `ConradsenCarbon` double DEFAULT NULL,
  `experiment_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `liqComp_ind_oilPhys` (`id`),
  CONSTRAINT `liqComp_fk_oilPhys` FOREIGN KEY (`id`) REFERENCES `liquidcomp` (`oil_phys_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `oilphysprops`
--

/*!40000 ALTER TABLE `oilphysprops` DISABLE KEYS */;
INSERT INTO `oilphysprops` (`id`,`density`,`viscosity`,`viscosity_temp`,`flashPoint`,`pourPoint`,`pH`,`HHV`,`HeatOfCombustion`,`WaterContent`,`ConradsenCarbon`,`experiment_id`) VALUES 
 (1,1.083,NULL,NULL,NULL,NULL,NULL,NULL,25852,21.09,NULL,1),
 (2,1.083,NULL,NULL,NULL,NULL,NULL,NULL,25542,21.09,NULL,2),
 (3,1.13,3.9,20,NULL,NULL,3.5,17250,NULL,NULL,NULL,37),
 (4,1.05,2.25,20,NULL,NULL,4.5,19910,NULL,NULL,NULL,38),
 (5,NULL,NULL,NULL,NULL,NULL,4.2,17300,NULL,NULL,NULL,43),
 (6,NULL,NULL,NULL,NULL,NULL,NULL,25600,NULL,NULL,NULL,61),
 (7,NULL,NULL,NULL,NULL,NULL,NULL,22800,NULL,NULL,NULL,62),
 (8,NULL,NULL,NULL,NULL,NULL,NULL,21300,NULL,NULL,NULL,63),
 (9,NULL,NULL,NULL,NULL,NULL,NULL,27100,NULL,NULL,NULL,64),
 (10,NULL,NULL,NULL,NULL,NULL,NULL,31400,NULL,NULL,NULL,65),
 (11,NULL,NULL,NULL,NULL,NULL,NULL,32300,NULL,NULL,NULL,66);
/*!40000 ALTER TABLE `oilphysprops` ENABLE KEYS */;


--
-- Definition of table `physprops`
--

DROP TABLE IF EXISTS `physprops`;
CREATE TABLE `physprops` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `diam_min` double DEFAULT NULL,
  `diam_max` double DEFAULT NULL,
  `length1` double DEFAULT NULL,
  `length2` double DEFAULT NULL,
  `length3` double DEFAULT NULL,
  `pred_diam` double DEFAULT NULL,
  `moisture_min` double DEFAULT NULL,
  `moisture_max` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_phys` (`id`),
  KEY `ref_ind_phys` (`ref_fk`),
  CONSTRAINT `exp_fk_phys` FOREIGN KEY (`id`) REFERENCES `experiment` (`physprops_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_phys` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `physprops`
--

/*!40000 ALTER TABLE `physprops` DISABLE KEYS */;
INSERT INTO `physprops` (`id`,`diam_min`,`diam_max`,`length1`,`length2`,`length3`,`pred_diam`,`moisture_min`,`moisture_max`,`ref_fk`) VALUES 
 (1,NULL,2,NULL,NULL,NULL,NULL,NULL,5,1),
 (2,NULL,2,NULL,NULL,NULL,NULL,NULL,5,1),
 (3,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (4,5,15,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (5,5,30,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (6,5,30,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (7,5,15,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (8,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (9,1,10,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (10,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (11,1,10,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (12,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (13,0.5,2,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (14,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (15,0.5,2,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (16,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (17,5,NULL,100,NULL,NULL,100,NULL,NULL,2),
 (18,5,NULL,5,NULL,NULL,5,NULL,NULL,2),
 (19,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (20,5,NULL,100,NULL,NULL,100,NULL,NULL,2),
 (21,5,NULL,5,NULL,NULL,5,NULL,NULL,2),
 (22,0.3,0.5,NULL,NULL,NULL,NULL,NULL,NULL,2),
 (23,NULL,NULL,2,5,10,5.75882382296972,NULL,NULL,3),
 (24,NULL,NULL,2,5,10,5.75882382296972,NULL,NULL,3),
 (25,NULL,0.005,NULL,NULL,NULL,NULL,NULL,NULL,3),
 (26,NULL,0.005,NULL,NULL,NULL,NULL,NULL,NULL,3),
 (27,NULL,0.005,NULL,NULL,NULL,NULL,NULL,NULL,3),
 (28,NULL,0.005,NULL,NULL,NULL,NULL,NULL,NULL,3),
 (29,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3),
 (30,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3),
 (31,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (32,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (33,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (34,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (35,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (36,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (37,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (38,0.5,1,NULL,NULL,NULL,NULL,NULL,NULL,4),
 (39,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,5),
 (40,NULL,5,5,NULL,NULL,5,NULL,NULL,5),
 (41,NULL,5,5,NULL,NULL,5,NULL,NULL,5),
 (42,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,6),
 (43,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,6),
 (44,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,6),
 (45,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (46,NULL,1.75,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (47,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (48,NULL,1.75,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (49,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (50,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (51,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (52,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (53,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (54,1.75,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7),
 (55,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,8),
 (56,NULL,NULL,20,20,5,15.6318528359354,NULL,NULL,9),
 (57,NULL,NULL,20,20,5,15.6318528359354,NULL,NULL,9),
 (58,NULL,NULL,20,20,5,15.6318528359354,NULL,NULL,9),
 (59,NULL,NULL,20,20,5,15.6318528359354,NULL,NULL,9),
 (60,NULL,NULL,20,20,5,15.6318528359354,NULL,NULL,9),
 (61,NULL,NULL,20,20,20,24.814019635976,NULL,NULL,9),
 (62,NULL,NULL,20,20,20,24.814019635976,NULL,NULL,9),
 (63,NULL,NULL,20,20,20,24.814019635976,NULL,NULL,9),
 (64,NULL,NULL,20,20,20,24.814019635976,NULL,NULL,9),
 (65,NULL,NULL,20,20,20,24.814019635976,NULL,NULL,9),
 (66,NULL,NULL,30,50,NULL,14.2024808461499,NULL,NULL,9),
 (67,NULL,NULL,30,50,NULL,14.2024808461499,NULL,NULL,9),
 (68,NULL,NULL,30,50,NULL,14.2024808461499,NULL,NULL,9),
 (69,NULL,NULL,20,30,NULL,10.4644773592106,NULL,NULL,9),
 (70,NULL,NULL,30,50,NULL,14.2024808461499,NULL,NULL,9),
 (71,0.62,1,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (72,0.62,1,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (73,0.62,1,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (74,0.62,1,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (75,0.62,1,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (76,0.62,1,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (77,0.62,1,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (78,0.4,0.63,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (79,1,1.6,NULL,NULL,NULL,NULL,NULL,NULL,10),
 (80,1.6,2,NULL,NULL,NULL,NULL,NULL,NULL,10);
/*!40000 ALTER TABLE `physprops` ENABLE KEYS */;


--
-- Definition of table `productcal`
--

DROP TABLE IF EXISTS `productcal`;
CREATE TABLE `productcal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `GCV` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_pcal` (`id`),
  KEY `ref_ind_pcal` (`ref_fk`),
  CONSTRAINT `exp_fk_pcal` FOREIGN KEY (`id`) REFERENCES `experiment` (`prodcal_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_pcal` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `productcal`
--

/*!40000 ALTER TABLE `productcal` DISABLE KEYS */;
/*!40000 ALTER TABLE `productcal` ENABLE KEYS */;


--
-- Definition of table `proxanal`
--

DROP TABLE IF EXISTS `proxanal`;
CREATE TABLE `proxanal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `moistureStatus` enum('as received','dry','dry ash-free') DEFAULT NULL,
  `moisture` double DEFAULT NULL,
  `ash` double DEFAULT NULL,
  `volatiles` double DEFAULT NULL,
  `fixedCarbon` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_prox` (`id`),
  KEY `ref_ind_prox` (`ref_fk`),
  CONSTRAINT `exp_fk_prox` FOREIGN KEY (`id`) REFERENCES `experiment` (`proxanal_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_prox` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `proxanal`
--

/*!40000 ALTER TABLE `proxanal` DISABLE KEYS */;
INSERT INTO `proxanal` (`id`,`moistureStatus`,`moisture`,`ash`,`volatiles`,`fixedCarbon`,`ref_fk`) VALUES 
 (1,'as received',5.25,8.28,69.55,16.94,1),
 (2,'as received',5.57,5.51,71.1,17.83,1),
 (3,'as received',8.9,2.1,66.2,22.2,2),
 (4,'as received',8.9,2.1,66.2,22.2,2),
 (5,'as received',8.9,2.1,66.2,22.2,2),
 (6,'as received',8.9,2.1,66.2,22.2,2),
 (7,'as received',8.9,2.1,66.2,22.2,2),
 (8,'as received',8.9,2.1,66.2,22.2,2),
 (9,'as received',11.5,8.1,56.3,24.1,2),
 (10,'as received',11.5,8.1,56.3,24.1,2),
 (11,'as received',11.5,8.1,56.3,24.1,2),
 (12,'as received',11.5,8.1,56.3,24.1,2),
 (13,'as received',8,2.3,64.5,25.1,2),
 (14,'as received',8,2.3,64.6,25.1,2),
 (15,'as received',8,2.3,64.6,25.1,2),
 (16,'as received',8.2,8.8,66.2,16.8,2),
 (17,'as received',8.2,8.8,66.2,16.8,2),
 (18,'as received',8.3,8.8,66.2,16.8,2),
 (19,'as received',8.2,8.8,66.2,16.8,2),
 (20,'as received',8.2,8.8,66.2,16.8,2),
 (21,'as received',8.2,8.8,66.2,16.8,2),
 (22,'as received',11.1,2.1,74.4,12.4,3),
 (23,'as received',11.1,2.1,74.4,12.4,3),
 (24,'as received',10,13.6,60.7,15.7,3),
 (25,'as received',10,13.6,60.7,15.7,3),
 (26,'as received',8.5,1.2,77.4,12.9,3),
 (27,'as received',8.5,1.2,77.4,12.9,3),
 (28,'as received',8.5,1.2,77.4,12.9,3),
 (29,'as received',8.5,1.26,77.4,12.9,3),
 (30,'as received',7.8,14.1,61.6,16.5,3),
 (31,'as received',7.8,14.1,61.6,16.5,3),
 (32,'as received',4,1.26,70,30.7,4),
 (33,'as received',4,1.26,70,30.7,4),
 (34,'as received',4,1.26,70,30.7,4),
 (35,'as received',4,1.26,70,30.7,4),
 (36,'as received',4,1.26,70,30.7,4),
 (37,'as received',4,1.26,70,30.7,4),
 (38,'as received',4,1.26,70,30.7,4),
 (39,'as received',4,1.26,70,30.7,4),
 (40,'as received',6.62,11.16,63.34,17.88,5),
 (41,'as received',6.62,11.16,63.34,17.88,5),
 (42,'as received',8.18,10.28,70.22,11.33,5),
 (43,'as received',9,4,NULL,NULL,6),
 (44,'as received',6.3,2.1,NULL,NULL,6),
 (45,'as received',7.2,4.1,NULL,NULL,6),
 (46,'as received',7.36,1.34,76.93,14.34,7),
 (47,'as received',7.39,1.34,76.93,14.34,7),
 (48,'as received',7.39,1.34,76.93,14.34,7),
 (49,'as received',7.39,134,76.93,14.34,7),
 (50,'as received',7.39,1.34,76.93,14.34,7),
 (51,'as received',7.39,1.34,76.93,14.34,7),
 (52,'as received',7.39,1.34,76.93,14.34,7),
 (53,'as received',7.39,1.34,76.93,14.34,7),
 (54,'as received',7.39,1.34,76.83,14.34,7),
 (55,'as received',7.39,1.34,76.93,14.34,7),
 (56,'as received',7.39,1.34,76.93,14.34,7),
 (57,'as received',2.65,2.54,81.2,13.81,8);
/*!40000 ALTER TABLE `proxanal` ENABLE KEYS */;


--
-- Definition of table `reference`
--

DROP TABLE IF EXISTS `reference`;
CREATE TABLE `reference` (
  `ref_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `author` varchar(300) DEFAULT NULL,
  `citation` varchar(400) DEFAULT NULL,
  `organizations` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`ref_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reference`
--

/*!40000 ALTER TABLE `reference` DISABLE KEYS */;
INSERT INTO `reference` (`ref_id`,`author`,`citation`,`organizations`) VALUES 
 (1,'A. A. Boateng (1), C. A. Mullen (1), N. Goldberg (1), K. B. Hicks (1), H. J. Jung (2), J. F. S. Lamb (2)','\"Production of Bio-oil from Alfalfa Stems by Fluidized-Bed Fast Pyrolysis\" Industrial Engineering  and Chemistry Research, Vol. 47, pp. 4115-4122, 2008.','(1) USDA Eastern Regional Research Center, Wyndmoor, PA, (2)  USDA-ARS Plant Science Research Unit, St. Paul, MN\n\n'),
 (2,'J. J. Manyá, J. Ruiz, and J. Arauzo','\"Some Peculiarities, of Conventional Pyrolysis of Several Agricultural Residues in a Packed Bed Reactor,\" Industrial and Engineering Chemistry Research, Vol. 46, pp. 9061-9070, 2007.','Aragón Institute of Engineering Research, University of Zaragoza, Maria de Luna 3, E-50018 Zarogoza, Spain\n\n'),
 (3,'Javier Herguido, José Corella, and José Gonazález-Saiz\n\n','\"Steam Gasification of Lignocellulosic Residues in a Fluidized Bed at a Small Pilot Scale.  Effect of the Type of Feedstock,\" Industrial and Engineering Chemistry Research, Vol. 31, pp. 1274-1282, 1992.','\n\nChemical and Environmental Engineering Department, University of Zaragoza, Zaragora, Spain '),
 (4,'M. Asadullan, M. A. Rahman, M. M. Ali, M. S.  Rahman, A. A. Motin, M. B. Sultan, and M. R. Alam','\"Production of Bio-oil from Fixed Bed Pyrolysis of Bagasse,\" Fuel, Vol. 86, pp.2514-2520, 2007.','Department of Applied Chemistry and Chemical Technology, University of Rajshahi, Rajshahi 6205, Bangladesh\n\n'),
 (5,'K. Lee, B. Kang, Y. Park, and J. Kim','\"Influence of Reaction Temperature, Pretreatment, and a Char Removal System on the Production of Bio-Oil from Rice Straw by fast Pyrolysis, Using a Fluidized Bed,\" Energy and Fuels, Vol.19, pp. 2179-2184, 2005.','University of Seoul, 90 Jeonnong-Dong, Dongdaemun-Gu, Seoul, Republic of Korea.\n\n'),
 (6,'J. Yanik, C. Kornmayer, M. Saglam, M. Yuksel','\"Fast Pyrolysis of Agricultural Wastes: Characterization of Pyrolysis Products,\" Fuel Processing Technology, Vol. 88, pp. 942-947, 2007.','Institute for Technical Chemistry, Division of Chemical-Physical Processing Forshungszentrum Karlsruhe, Eggenstein-Leopoldshafen, Germany.\n\n'),
 (7,'A. E. Putun (1), N. Özbay (2),  E. A, Varol (1).  B. B. Uzun (1), and F. Ates (1)\n\n','Rapid and Slow Pyrolysis of Pistachio Shell: Effect of Pyrolysis Conditions on the Product Yields and Characterizaton of the Liquid Product,\" International Journal of Energy Research, Vol. 31, pp.506-514, 2007.','(1) Department of Chemical Engineering, Anadolu University, 26470 Eskisehir, Turkey, (2) Bozüyük Vocational School, Anadolu University, Bozüyük/Bilecik, Turkey\n\n'),
 (8,'A. A. Boateng (1), D.E. Daugaard (2), N. M. Goldberg (1), and K. B. Hicks (10','\"Bench-Scale Fluidized Bed Pyrolysis of Switchgrass for Bio-Oil Production,\" Industrial Engineering Chemistry Research, Vol. 46, pp. 1891-1897, 2008.','(1) USDA Eastern Regional Research Center, Wyndmoor, PA, (2) University of Texas, San Antonio, TX'),
 (9,'A. N. Phan, C. Ryu, V. N. Sharifi, J. Swithenbank','\"Characterization of Slow Pyrolysis Products from Segregated Wastes for Energy Production,\" Journal Analytical and Applied Pyrolysis, Vol. 81, pp.65-71, 2008.\n\n','Department of Chemical and Process Engineering, The University of Sheffield, United Kingdom\n\n'),
 (10,'J. L. Figueiredo (1), C. Valenzuela (1),  A. Bernalte (1), and J. M. Encinar (2)\n\n','\"Pyrolysis of Holm-Oak Wood: Influence of Temperature and Particle Size,\" Fuel, pp. 1012-1016, 1989.','(1) Centro de Engenharia Quimica (INIC), Faculdade de Engenharia, Porto Portugal Dpto. de Quimica Inorganica, Facultad de Ciencias, Badajoz, Spain, (2)  Dpto. de Ingenieria Quimica y Energética, Facultad de Ciencias, Badajoz, Spain.');
/*!40000 ALTER TABLE `reference` ENABLE KEYS */;


--
-- Definition of table `struct`
--

DROP TABLE IF EXISTS `struct`;
CREATE TABLE `struct` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lignin` double DEFAULT NULL,
  `ligninMethod` varchar(30) DEFAULT NULL,
  `cellulose` double DEFAULT NULL,
  `hemicellulose` double DEFAULT NULL,
  `extractives` double DEFAULT NULL,
  `cellwall` double DEFAULT NULL,
  `pectin` double DEFAULT NULL,
  `sol_sugars_stch` double DEFAULT NULL,
  `xylan` double DEFAULT NULL,
  `glucomannan` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  `galactan` double DEFAULT NULL,
  `arabinan` double DEFAULT NULL,
  `mannan` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ref_ind_struct` (`ref_fk`),
  KEY `exp_ind_struct` (`id`),
  CONSTRAINT `exp_fk_struct` FOREIGN KEY (`id`) REFERENCES `experiment` (`struct_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_struct` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `struct`
--

/*!40000 ALTER TABLE `struct` DISABLE KEYS */;
INSERT INTO `struct` (`id`,`lignin`,`ligninMethod`,`cellulose`,`hemicellulose`,`extractives`,`cellwall`,`pectin`,`sol_sugars_stch`,`xylan`,`glucomannan`,`ref_fk`,`galactan`,`arabinan`,`mannan`) VALUES 
 (1,14.1,'Klason',26.5,12.2,NULL,70.8,13.4,4.6,NULL,NULL,1,NULL,NULL,NULL),
 (2,16.9,'Klason',28.5,12.3,NULL,75,13,4.3,NULL,NULL,1,NULL,NULL,NULL),
 (3,21.1,'',NULL,NULL,2.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (4,21.1,'',NULL,NULL,2.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (5,21.1,'',NULL,NULL,2.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (6,21.1,'',NULL,NULL,2.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (7,21.1,'',NULL,NULL,2.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (8,21.1,'',NULL,NULL,2.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (9,34,'',NULL,NULL,15.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (10,34,'',NULL,NULL,15.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (11,34,'',NULL,NULL,15.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (12,34,'',NULL,NULL,15.1,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (13,31.2,'',NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (14,31.2,'',NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (15,31.2,'',NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (16,31.2,'',NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (17,17,'',NULL,NULL,3.8,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (18,17,'',NULL,NULL,3.8,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (19,17,'',NULL,NULL,3.8,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (20,17,'',NULL,NULL,3.8,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (21,17,'',NULL,NULL,3.8,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (22,17,'',NULL,NULL,3.8,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL),
 (23,12.83,'',54.64,32.53,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL),
 (24,12.83,'',54.64,32.53,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL),
 (25,12.83,'',54.64,32.53,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL),
 (26,10.9,'',33.8,9.3,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL),
 (27,31.7,'',31.7,3.4,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL),
 (28,12.2,'',34.5,14.2,NULL,NULL,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL),
 (29,12.8,'',60.62,2.44,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (30,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (31,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (32,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (33,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (34,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (35,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (36,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (37,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (38,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL),
 (39,12.8,'',60.62,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,NULL,NULL,NULL);
/*!40000 ALTER TABLE `struct` ENABLE KEYS */;


--
-- Definition of table `ultanal`
--

DROP TABLE IF EXISTS `ultanal`;
CREATE TABLE `ultanal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `moistureStatus` enum('as received','dry','dry ash-free') DEFAULT NULL,
  `moisture` double DEFAULT NULL,
  `ash` double DEFAULT NULL,
  `H` double DEFAULT NULL,
  `C` double DEFAULT NULL,
  `N` double DEFAULT NULL,
  `O` double DEFAULT NULL,
  `O_calc` tinyint(1) DEFAULT NULL,
  `Cl` double DEFAULT NULL,
  `S` double DEFAULT NULL,
  `H_C` double DEFAULT NULL,
  `H_C_calc` tinyint(1) DEFAULT NULL,
  `O_C` double DEFAULT NULL,
  `O_C_calc` tinyint(1) DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_ult` (`id`),
  KEY `ref_ind_ult` (`ref_fk`),
  CONSTRAINT `exp_fk_ult` FOREIGN KEY (`id`) REFERENCES `experiment` (`ultanal_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_ult` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ultanal`
--

/*!40000 ALTER TABLE `ultanal` DISABLE KEYS */;
INSERT INTO `ultanal` (`id`,`moistureStatus`,`moisture`,`ash`,`H`,`C`,`N`,`O`,`O_calc`,`Cl`,`S`,`H_C`,`H_C_calc`,`O_C`,`O_C_calc`,`ref_fk`) VALUES 
 (1,'as received',4.97,7.87,5.45,38.89,2.27,38.82,0,0.53,0.2,7.04,0,1.03,0,1),
 (2,'as received',5.28,5.22,5.53,41.12,1.43,40.98,0,0.37,0.08,7.44,0,1.003,0,1),
 (3,'dry ash-free',NULL,NULL,5.4,50.2,0.4,44,0,NULL,NULL,9.3,0,1.14,0,2),
 (4,'dry ash-free',NULL,NULL,5.4,50.2,0.4,44,0,NULL,NULL,9.3,0,1.14,0,2),
 (5,'as received',NULL,NULL,5.4,50.2,0.4,44,0,NULL,NULL,9.3,0,1.14,0,2),
 (6,'as received',NULL,NULL,5.4,50.2,0.4,44,0,NULL,NULL,9.3,0,1.14,0,2),
 (7,'as received',NULL,NULL,5.4,50.2,0.4,44,0,NULL,NULL,9.3,0,1.14,0,2),
 (8,'as received',NULL,NULL,5.4,50.2,0.4,44,0,NULL,NULL,9.3,0,1.14,0,2),
 (9,'as received',NULL,NULL,6.5,47.9,2.9,42.5,0,NULL,0.2,7.37,0,1.13,0,2),
 (10,'as received',NULL,NULL,6.5,47.9,2.9,42.5,0,NULL,0.2,7.37,0,1.13,0,2),
 (11,'as received',NULL,NULL,6.5,47.9,2.9,42.5,0,NULL,0.2,7.37,0,1.13,0,2),
 (12,'as received',NULL,NULL,6.5,47.9,2.9,42.3,0,NULL,0.2,NULL,1,NULL,1,2),
 (13,'as received',NULL,NULL,6,47.1,2.4,44.4,0,NULL,0.2,7.85,0,1.06,0,2),
 (14,'as received',NULL,NULL,6,47.1,2.4,44.4,0,NULL,0.2,7.85,0,1.06,0,2),
 (15,'dry ash-free',NULL,NULL,6,47.1,2.4,44.4,0,NULL,0.2,7.85,0,1.06,0,2),
 (16,'as received',NULL,NULL,6,47.1,2.4,44.4,0,NULL,0.2,7.85,0,1.06,0,2),
 (17,'as received',NULL,NULL,5.2,44.3,0.1,50.3,0,NULL,0.2,8.52,0,0.88,0,2),
 (18,'dry ash-free',NULL,NULL,5.2,44.3,0.2,50.3,0,NULL,0.1,8.52,0,0.88,0,2),
 (19,'dry ash-free',NULL,NULL,5.2,44.3,0.1,50.3,0,NULL,0.2,8.52,0,0.88,0,2),
 (20,'dry ash-free',NULL,NULL,5.2,44.3,0.2,50.3,0,NULL,0.1,8.52,0,0.88,0,2),
 (21,'dry ash-free',NULL,NULL,5.2,44.3,0.1,50.3,0,NULL,0.1,8.52,0,0.88,0,2),
 (22,'dry ash-free',NULL,NULL,5.2,44.3,0.1,50.3,0,NULL,0.1,8.52,0,0.88,0,2),
 (23,'dry ash-free',NULL,NULL,5.3,41.8,0.2,NULL,1,NULL,NULL,7.9,0,NULL,1,3),
 (24,'dry ash-free',NULL,NULL,5.3,41.8,0.2,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (25,'dry ash-free',NULL,NULL,5.5,40.8,0.3,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (26,'dry ash-free',NULL,NULL,5.5,40.8,0.3,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (27,'dry ash-free',NULL,NULL,6.3,42.5,0.2,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (28,'dry ash-free',NULL,NULL,6.3,42.3,0.2,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (29,'dry ash-free',NULL,NULL,6.3,42.5,0.2,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (30,'dry ash-free',NULL,NULL,6.3,42.5,0.2,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (31,'dry ash-free',NULL,NULL,6.1,43.7,0.4,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (32,'dry ash-free',NULL,NULL,6.1,43.7,0.4,NULL,1,NULL,NULL,NULL,1,NULL,1,3),
 (33,'dry ash-free',NULL,NULL,5.97,48.58,0.2,38.94,0,NULL,0.05,NULL,1,NULL,1,4),
 (34,'as received',NULL,NULL,5.97,48.58,0.2,38.94,0,0.05,0.05,NULL,1,NULL,1,4),
 (35,'as received',NULL,NULL,5.97,48.58,0.2,38.94,0,0.05,0.05,NULL,1,NULL,1,4),
 (36,'as received',NULL,NULL,5.97,48.58,0.2,38.94,0,0.05,0.05,NULL,1,NULL,1,4),
 (37,'as received',NULL,NULL,5.97,48.58,0.2,38.94,0,0.05,0.05,NULL,1,NULL,1,4),
 (38,'as received',NULL,NULL,5.97,48.58,0.2,38.94,0,0.05,0.05,NULL,1,NULL,1,4),
 (39,'dry ash-free',NULL,NULL,5.97,48.58,0.2,38.94,0,0.05,0.05,NULL,1,NULL,1,4),
 (40,'dry ash-free',NULL,NULL,5.97,48.58,0.2,38.94,0,0.05,0.05,NULL,1,NULL,1,4),
 (41,'dry ash-free',NULL,NULL,4.84,39.2,1.6,53.69,0,NULL,0.67,NULL,1,NULL,1,5),
 (42,'dry ash-free',NULL,NULL,4.84,39.2,1.6,53.69,0,NULL,0.67,NULL,1,NULL,1,5),
 (43,'as received',NULL,NULL,8.5,40.9,0.01,49.4,0,NULL,0.13,NULL,1,NULL,1,5),
 (44,'dry',NULL,NULL,6,42.9,0.7,NULL,1,1.15,0.29,NULL,1,NULL,1,6),
 (45,'dry',NULL,NULL,6.4,42.9,0.6,NULL,1,0.59,0.29,NULL,1,NULL,1,6),
 (46,'dry',NULL,NULL,6.54,43.89,0.42,NULL,1,1.88,0.51,NULL,1,NULL,1,6),
 (47,'dry ash-free',NULL,NULL,6.16,49.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (48,'dry ash-free',NULL,NULL,6.16,49.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (49,'dry ash-free',NULL,NULL,6.16,49.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (50,'dry ash-free',NULL,NULL,6.16,48.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (51,'dry ash-free',NULL,NULL,6.16,49.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (52,'dry ash-free',NULL,NULL,6.16,49.98,1.59,42.47,0,NULL,NULL,NULL,1,NULL,1,7),
 (53,'dry ash-free',NULL,NULL,6.16,49.48,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (54,'as received',NULL,NULL,6.16,49.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (55,'dry ash-free',NULL,NULL,6.16,49.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (56,'dry ash-free',NULL,NULL,6.16,49.98,1.59,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (57,'dry ash-free',NULL,NULL,6.16,49.98,1.5,42.27,0,NULL,NULL,NULL,1,NULL,1,7),
 (58,'dry ash-free',NULL,NULL,6.99,48.8,0.53,43.68,0,NULL,NULL,NULL,1,NULL,1,8);
/*!40000 ALTER TABLE `ultanal` ENABLE KEYS */;


--
-- Definition of table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `User_Code` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Login_Name` varchar(50) NOT NULL,
  `First_Name` varchar(100) NOT NULL,
  `Last_Name` varchar(100) NOT NULL,
  `Email` varchar(250) NOT NULL,
  `User_Password` varchar(250) NOT NULL,
  PRIMARY KEY (`User_Code`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`User_Code`,`Login_Name`,`First_Name`,`Last_Name`,`Email`,`User_Password`) VALUES 
 (1,'admin','Teva','Velu','t.veluppillai@gmail.com','abc123'),
 (2,'rbreid','Richard','Reid','privyet@gmail.com','ri430ch'),
 (3,'jkp','Judy','Partin','Judy.Partin@inl.gov','titan'),
 (4,'Teva','Tevaganthan','Veluppillai','t.veluppillai@gmail.com','abc123'),
 (7,'Derrick','Derrick','Kozub','derrick.kozub@shell.com','Kozub');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;


--
-- Definition of table `yields`
--

DROP TABLE IF EXISTS `yields`;
CREATE TABLE `yields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gas` double DEFAULT NULL,
  `gasComp_fk` int(10) unsigned DEFAULT NULL,
  `chr` double DEFAULT NULL,
  `chrComp_fk` int(10) unsigned DEFAULT NULL,
  `liquid` double DEFAULT NULL,
  `liquidComp_fk` int(10) unsigned DEFAULT NULL,
  `tar` double DEFAULT NULL,
  `ref_fk` int(10) unsigned DEFAULT NULL,
  `experiment_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `exp_ind_yds` (`id`),
  KEY `ref_ind_yds` (`ref_fk`),
  KEY `gasComp` (`gasComp_fk`),
  KEY `chrComp` (`chrComp_fk`),
  KEY `liquidComp` (`liquidComp_fk`),
  CONSTRAINT `exp_fk_yds` FOREIGN KEY (`id`) REFERENCES `experiment` (`yields_fk`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ref_fk_yds` FOREIGN KEY (`ref_fk`) REFERENCES `reference` (`ref_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `yields`
--

/*!40000 ALTER TABLE `yields` DISABLE KEYS */;
INSERT INTO `yields` (`id`,`gas`,`gasComp_fk`,`chr`,`chrComp_fk`,`liquid`,`liquidComp_fk`,`tar`,`ref_fk`,`experiment_id`) VALUES 
 (1,16.3,0,38.5,1,45,1,NULL,1,1),
 (2,12.8,0,34,2,53,2,NULL,1,2),
 (5,30,1,26,0,44,0,NULL,2,3),
 (6,23.5,0,24,18,52,0,NULL,2,4),
 (7,22.5,0,25,0,52.5,0,NULL,2,5),
 (8,41,0,26,0,33,0,NULL,2,6),
 (9,42,0,23,0,41,0,NULL,2,7),
 (10,37,2,25,0,38,0,NULL,2,8),
 (11,30,0,27.5,0,38.5,0,NULL,2,9),
 (12,26.5,3,28,0,40,0,NULL,2,10),
 (13,45,0,22.5,0,32.5,0,NULL,2,11),
 (14,39,4,23,0,32.5,0,NULL,2,12),
 (15,32.5,0,33.5,0,34,0,NULL,2,13),
 (16,38,5,26,0,36,0,NULL,2,16),
 (17,35,0,21.5,0,43.5,0,NULL,2,17),
 (18,35,0,23.5,0,41.5,0,NULL,2,18),
 (19,36,6,22,0,42,0,NULL,2,19),
 (20,40.5,0,22,0,37.5,0,NULL,2,20),
 (21,42,0,21.5,0,36,0,NULL,2,21),
 (22,42.5,7,21.5,0,36,0,NULL,2,22),
 (23,60,8,28,0,NULL,0,6.8,3,23),
 (24,71,9,21,0,NULL,0,3.8,3,24),
 (25,43,10,29,0,NULL,0,6.2,3,25),
 (26,59,11,18,0,NULL,0,4.1,3,26),
 (27,85,0,18,0,NULL,0,4,3,27),
 (28,110,0,3,0,NULL,0,1,3,28),
 (29,60,12,22,0,NULL,0,6,3,29),
 (30,118,13,8,0,NULL,0,3,3,30),
 (31,50,14,22.5,0,NULL,0,7.2,3,31),
 (32,80,15,10,0,NULL,0,3,3,32),
 (33,4.34,0,77,0,18.66,0,NULL,4,33),
 (34,4.87,0,43.8,0,51.32,0,NULL,4,34),
 (35,7.41,0,31.93,0,60.66,0,NULL,4,35),
 (36,8.27,0,26.26,0,65.47,0,NULL,4,36),
 (37,9.01,0,24.86,0,66.13,3,NULL,4,37),
 (38,9.01,0,24.86,0,66.13,0,NULL,4,38),
 (39,14.71,0,24.66,0,60.63,0,NULL,4,39),
 (40,17.82,0,22.86,0,59.52,0,NULL,4,40),
 (41,17,16,32,0,50,0,NULL,5,41),
 (42,41,0,25,0,32,0,NULL,5,42),
 (43,18,17,22,0,58,0,NULL,5,43),
 (44,32,0,23,3,45,6,NULL,6,44),
 (45,30,0,23,4,47,7,NULL,6,45),
 (46,39,0,20,5,41,8,NULL,6,46),
 (47,36,0,22,0,27,0,NULL,7,48),
 (48,40,0,26,0,20.5,10,NULL,7,49),
 (49,47,0,15.5,0,22.5,11,NULL,7,50),
 (50,0,0,0,0,0,12,0,7,51),
 (51,37.5,0,21.5,0,27,13,NULL,7,52),
 (52,41,0,21,0,24,14,NULL,7,53),
 (53,42.5,0,27.5,0,21,15,NULL,7,54),
 (54,40,0,24.5,0,22.5,16,NULL,7,55),
 (55,37,0,23,0,27,17,NULL,7,56),
 (56,41,0,21,0,24,18,NULL,7,57),
 (57,11.3,18,12.9,6,60.7,19,NULL,8,58),
 (59,36.2,0,33.9,0,29.9,0,NULL,9,59),
 (60,39.3,0,29.9,0,30.8,0,NULL,9,60),
 (61,39.5,0,28,0,32.5,20,NULL,9,61),
 (62,41.8,0,26.2,0,32,0,NULL,9,62),
 (63,42.3,19,25.9,0,31.8,22,NULL,9,63),
 (64,22.2,0,33.2,0,44.6,23,NULL,9,64),
 (65,29.1,0,27.4,0,43.5,0,NULL,9,65),
 (66,31.3,0,24.3,0,44.4,26,NULL,9,66),
 (67,33.1,0,22.2,0,44.7,0,NULL,9,67),
 (68,41.3,20,21.6,0,37.1,27,NULL,9,68),
 (69,30,0,31.6,0,38.4,28,0,9,69),
 (70,32.9,0,24.6,0,42.5,0,NULL,9,70),
 (71,31.9,0,22,0,46.1,29,NULL,9,71),
 (72,33.5,0,19.5,0,47,0,NULL,9,72),
 (73,45.8,0,19,0,35.2,30,NULL,9,73),
 (74,17.6,0,57.4,8,25,0,NULL,10,74),
 (75,29.3,0,29.5,9,41.2,0,NULL,10,75),
 (76,30.8,0,24.9,7,44.3,0,NULL,10,76),
 (79,35.1,0,21.9,10,43,0,NULL,10,77),
 (80,42,0,20.7,11,37.3,0,NULL,10,78),
 (81,53.5,0,18.4,12,28.1,0,NULL,10,79),
 (82,56.6,0,18.4,13,25,0,NULL,10,80),
 (83,28.8,0,25.1,14,46.1,0,NULL,10,81),
 (84,29.5,0,25.5,15,45,0,NULL,10,82),
 (85,28.9,0,25,16,46.1,0,NULL,10,83);
/*!40000 ALTER TABLE `yields` ENABLE KEYS */;


--
-- Definition of procedure `AddMaterialClass`
--

DROP PROCEDURE IF EXISTS `AddMaterialClass`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `AddMaterialClass`(IN vcMaterialClass varchar(50))
BEGIN
SET foreign_key_checks = 0;
insert into material (class,ref_fk) values (vcMaterialClass,@rfk);
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `AshAnalysis_GetRecentId`
--

DROP PROCEDURE IF EXISTS `AshAnalysis_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `AshAnalysis_GetRecentId`()
BEGIN
Select id from ashanal where id=@ash_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `AshAnal_Save`
--

DROP PROCEDURE IF EXISTS `AshAnal_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `AshAnal_Save`(
  IN vc_AshProdMethod VARCHAR(100), IN do_CO2 DOUBLE, IN do_SO3 DOUBLE,
  IN do_P2O5 DOUBLE, IN do_SiO2 DOUBLE, IN do_Fe2O3 DOUBLE, IN do_Al2O3 DOUBLE,
  IN do_CaO DOUBLE, IN do_MgO DOUBLE, IN do_Na2O DOUBLE, IN do_K2O DOUBLE,
  IN do_TiO2 DOUBLE, IN do_Pb DOUBLE, IN do_Cd DOUBLE, IN do_Cl DOUBLE,
  IN do_Cu DOUBLE, IN do_Hg DOUBLE, IN do_Mn DOUBLE, IN do_Cr DOUBLE)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO AshAnal ( ashProdMethod, CO2, SO3, P2O5, SiO2, Fe2O3, Al2O3, CaO, MgO,
  Na2O, K2O, TiO2, Pb, Cd, Cl, Cu, Hg, Mn, Cr, ref_fk, cref_fk)
  VALUES(
  vc_AshProdMethod, do_CO2, do_SO3, do_P2O5, do_SiO2, do_Fe2O3, do_Al2O3, do_CaO,
  do_MgO, do_Na2O, do_K2O, do_TiO2, do_Pb, do_Cd, do_Cl, do_Cu, do_Hg, do_Mn, do_Cr,
  @rfk, @crfk
  ) ;
SET @ash_id = LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `AshAnal_Update`
--

DROP PROCEDURE IF EXISTS `AshAnal_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `AshAnal_Update`(
  IN vc_AshProdMethod VARCHAR(100), IN do_CO2 DOUBLE, IN do_SO3 DOUBLE,
  IN do_P2O5 DOUBLE, IN do_SiO2 DOUBLE, IN do_Fe2O3 DOUBLE, IN do_Al2O3 DOUBLE,
  IN do_CaO DOUBLE, IN do_MgO DOUBLE, IN do_Na2O DOUBLE, IN do_K2O DOUBLE,
  IN do_TiO2 DOUBLE, IN do_Pb DOUBLE, IN do_Cd DOUBLE, IN do_Cl DOUBLE,
  IN do_Cu DOUBLE, IN do_Hg DOUBLE, IN do_Mn DOUBLE, IN do_Cr DOUBLE,
  IN int_Id int
 )
BEGIN
Update AshAnal
Set
ashProdMethod = vc_AshProdMethod,
CO2 = do_CO2, 
SO3=do_SO3,  
P2O5=do_P2O5,  
SiO2=do_SiO2,  
Fe2O3=do_Fe2O3,  
Al2O3=do_Al2O3,  
CaO=do_CaO, 
MgO=do_MgO, 
Na2O=do_Na2O,  
K2O=do_K2O,  
TiO2=do_TiO2,  
Pb=do_Pb,  
Cd=do_Cd,  
Cl=do_Cl,  
Cu=do_Cu,  
Hg=do_Hg,  
Mn=do_Mn,  
Cr=do_Cr
where
id=int_Id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `CalAnalysis_GetRecentId`
--

DROP PROCEDURE IF EXISTS `CalAnalysis_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `CalAnalysis_GetRecentId`()
BEGIN
Select id from calanal where id=@cal_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `CalAnal_Save`
--

DROP PROCEDURE IF EXISTS `CalAnal_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `CalAnal_Save`(
  IN vc_moistureStatus VARCHAR(15), IN do_HHV DOUBLE, IN do_LHV DOUBLE)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO CalAnal ( moistureStatus, HHV, LHV, ref_fk, cref_fk)
  VALUES(
  vc_moistureStatus, do_HHV, do_LHV, @rfk, @cref_fk);
SET @cal_id=LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `CalAnal_Update`
--

DROP PROCEDURE IF EXISTS `CalAnal_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `CalAnal_Update`(IN vc_moistureStatus VARCHAR(15), IN do_HHV DOUBLE, IN do_LHV DOUBLE,IN int_Id int)
BEGIN
Update calanal
Set
moistureStatus=vc_moistureStatus,
HHV=do_HHV,  
LHV=do_LHV  
where
id=int_Id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ChrCompo_GetRecentId`
--

DROP PROCEDURE IF EXISTS `ChrCompo_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `ChrCompo_GetRecentId`()
BEGIN
Select id from ChrComp where id=@chrcompos_Id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ChrComp_Save`
--

DROP PROCEDURE IF EXISTS `ChrComp_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `ChrComp_Save`(
  IN do_C DOUBLE, IN do_H DOUBLE, IN do_N DOUBLE, IN do_S DOUBLE, IN do_Ash DOUBLE,IN intexperimentId int(10))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO ChrComp(C, H, N, S, Ash,experiment_id)
  VALUES(do_C, do_H, do_N, do_S, do_Ash,intexperimentId);
SET foreign_key_checks = 0;
SET @chrcompos_Id=LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ConvConditions_GetRecentId`
--

DROP PROCEDURE IF EXISTS `ConvConditions_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `ConvConditions_GetRecentId`()
BEGIN
Select id from ConvConditions where id=@conv_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ConvConditions_Save`
--

DROP PROCEDURE IF EXISTS `ConvConditions_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `ConvConditions_Save`(
  IN vc_Conv_regime VARCHAR(50), IN vc_ReactorConfig VARCHAR(100),
  IN vc_BedMedium VARCHAR(50), IN vc_FeedSystem VARCHAR(100),
  IN vc_GasificationMed VARCHAR(50), IN do_gasBiomassRatio DOUBLE,
  IN do_FeedRate_min DOUBLE, IN do_FeedRate_max DOUBLE,
  IN do_Temp DOUBLE, IN do_Pressure DOUBLE, IN do_HeatRate_min DOUBLE,
  IN do_HeatRate_max DOUBLE, IN do_resTime_min DOUBLE, IN do_resTime_max DOUBLE,IN do_sweptGasVelocity double)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO ConvConditions
  (
  conv_regime,
  reactorConfig,
  bedMedium,
  feedsystem,
  gasificationMed,
  gasBiomassRatio,
  feedRate_min,
  feedRate_max,
  temp,
  pressure,
  heatRate_min,
  heatRate_max,
  resTime_min,
  resTime_max,
  ref_fk,
  sweptGasVelocity
  )
  Values(
  vc_Conv_regime,
  vc_ReactorConfig,
  vc_BedMedium,
  vc_FeedSystem,
  vc_GasificationMed,
  do_gasBiomassRatio,
  do_FeedRate_min,
  do_FeedRate_max,
  do_Temp,
  do_Pressure,
  do_HeatRate_min,
  do_HeatRate_max,
  do_ResTime_min,
  do_ResTime_max,
  @rfk,
  do_sweptGasVelocity
  );
SET @conv_id=LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ConvConditions_Update`
--

DROP PROCEDURE IF EXISTS `ConvConditions_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `ConvConditions_Update`(
IN vc_Conv_regime VARCHAR(50), IN vc_ReactorConfig VARCHAR(100),
  IN vc_BedMedium VARCHAR(50), IN vc_FeedSystem VARCHAR(100),
  IN vc_GasificationMed VARCHAR(50), IN do_gasBiomassRatio DOUBLE,
  IN do_FeedRate_min DOUBLE, IN do_FeedRate_max DOUBLE,
  IN do_Temp DOUBLE, IN do_Pressure DOUBLE, IN do_HeatRate_min DOUBLE,
  IN do_HeatRate_max DOUBLE, IN do_resTime_min DOUBLE, IN do_resTime_max DOUBLE,IN do_sweptGasVelocity double,
  IN intId int
 )
BEGIN
Update ConvConditions
set
  conv_regime=vc_Conv_regime,
  reactorConfig=vc_ReactorConfig,
  bedMedium=vc_BedMedium,
  feedsystem=vc_FeedSystem,
  gasificationMed=vc_GasificationMed,
  gasBiomassRatio=do_gasBiomassRatio,
  feedRate_min=do_FeedRate_min,
  feedRate_max=do_FeedRate_max,
  temp=do_Temp,
  pressure=do_Pressure,
  heatRate_min=do_HeatRate_min,
  heatRate_max=do_HeatRate_max,
  resTime_min=do_ResTime_min,
  resTime_max=do_ResTime_max,
  ref_fk=@rfk,
  sweptGasVelocity=do_sweptGasVelocity
where
id=intId;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Experiment_GetRecentId`
--

DROP PROCEDURE IF EXISTS `Experiment_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Experiment_GetRecentId`()
BEGIN
Select experiment_id from Experiment where experiment_id=@exp_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Experiment_Save`
--

DROP PROCEDURE IF EXISTS `Experiment_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Experiment_Save`( IN txt_Exp_summary TEXT )
BEGIN
  INSERT INTO Experiment(
  exp_summary, ashanal_fk, calanal_fk, convcond_fk, material_fk, physprops_fk, prodcal_fk,
  proxanal_fk, struct_fk, ultanal_fk, yields_fk)
  VALUES( txt_Exp_summary, @ash_id, @cal_id, @conv_id, @mat_id, @phys_id, @pcal_id,
  @prox_id, @struct_id, @ult_id, @yields_id);
SET @exp_id = LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Gascomps_misc_GetRecentId`
--

DROP PROCEDURE IF EXISTS `Gascomps_misc_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Gascomps_misc_GetRecentId`()
BEGIN
Select id from gascomps_misc where id=@gasComp_misc_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Gascomps_misc_Save`
--

DROP PROCEDURE IF EXISTS `Gascomps_misc_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Gascomps_misc_Save`(IN vc_Component varchar(45),IN do_RelativeContent double,IN tiInt_Detected tinyint(1))
BEGIN
SET foreign_key_checks = 0;
insert into gascomps_misc (component,relativeContent,detected) values (vc_Component,do_RelativeContent,tiInt_Detected);
SET @gasComp_misc_id=LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `GasComp_GetRecentId`
--

DROP PROCEDURE IF EXISTS `GasComp_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `GasComp_GetRecentId`()
BEGIN
Select id from gasComp where id=@gasComp_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `GasComp_Save`
--

DROP PROCEDURE IF EXISTS `GasComp_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `GasComp_Save`(
  IN do_H2 DOUBLE, IN do_CO DOUBLE, IN do_CO2 DOUBLE, IN do_CH4 DOUBLE, IN do_C2H2 DOUBLE,IN do_C2H4 double,
  IN do_C2H6 DOUBLE, IN do_N2 DOUBLE,IN do_GCV double,IN do_Tar double,IN intExperimentId int(10))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO GasComp(H2, CO, CO2, CH4, C2H2,C2H4,C2H6, N2,GCV,Tar,experiment_id)
  VALUES(do_H2, do_CO, do_CO2, do_CH4, do_C2H2, do_C2H4,do_C2H6, do_N2,do_GCV,do_Tar,intExperimentId);
SET foreign_key_checks = 1;
SET @gasComp_id=LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `LiquidComposition_GetRecentId`
--

DROP PROCEDURE IF EXISTS `LiquidComposition_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `LiquidComposition_GetRecentId`()
BEGIN
Select id from LiquidComp where id=@LiquidComposId;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `LiquidComp_Save`
--

DROP PROCEDURE IF EXISTS `LiquidComp_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `LiquidComp_Save`(
  IN do_aqueous DOUBLE, IN do_oil DOUBLE, IN do_water DOUBLE,IN int_oil_ult_fk int,IN int_oil_phys_fk int,IN int_oilcomp_fk int,IN intexperiment_id int(10))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO LiquidComp(aqueous, oil, water, oil_ult_fk, oil_phys_fk, oilcomp_fk,experiment_id)
  VALUES(do_aqueous, do_oil, do_water,int_oil_ult_fk,int_oil_phys_fk,int_oilcomp_fk,intexperiment_id);
SET @LiquidComposId = LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Material_GetId`
--

DROP PROCEDURE IF EXISTS `Material_GetId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Material_GetId`(IN vcClass varchar(50))
BEGIN
Select Id from material where class = vcClass;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Material_GetRecentId`
--

DROP PROCEDURE IF EXISTS `Material_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Material_GetRecentId`()
BEGIN
Select id from material where id=@mat_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Material_Save`
--

DROP PROCEDURE IF EXISTS `Material_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Material_Save`(
  IN vc_Name VARCHAR(50), IN vc_Class VARCHAR(50),
  IN vc_Source VARCHAR(200), IN vc_HandlingHistory VARCHAR(300))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO Material (name, class, source, handlingHistory, ref_fk)
  VALUES( vc_Name, vc_Class, vc_Source, vc_HandlingHistory, @rfk);
SET foreign_key_checks = 1;
SET @mat_id=LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Material_Update`
--

DROP PROCEDURE IF EXISTS `Material_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Material_Update`(IN vcName varchar(50),IN vcClass varchar(50),IN vcSource varchar(200),IN vcHandlingHistory varchar(300),IN intId int)
BEGIN
update material
Set
name=vcName,
class=vcClass,
source=vcSource,
handlingHistory= vcHandlingHistory
where
id=intId;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `OilComponentMisc_GetRecentId`
--

DROP PROCEDURE IF EXISTS `OilComponentMisc_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `OilComponentMisc_GetRecentId`()
BEGIN
Select id from oilcomps_misc where id= LAST_INSERT_ID();

END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `OilComponents_GetRecentId`
--

DROP PROCEDURE IF EXISTS `OilComponents_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `OilComponents_GetRecentId`()
BEGIN
Select id from  OilComponents where id=@OilComp_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `OilComponents_Save`
--

DROP PROCEDURE IF EXISTS `OilComponents_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `OilComponents_Save`(
  IN do_Aliphatic DOUBLE, IN do_Aromatic DOUBLE, IN do_Polar DOUBLE,IN intmisc_fk int,IN intexperimentId int(10))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO OilComponents(aliphatic, aromatic, polar,misc_fk,experiment_id)
  VALUES(do_Aliphatic, do_Aromatic, do_Polar,intmisc_fk,intexperimentId);
SET @OilComp_id=LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `OilComps_Misc_Save`
--

DROP PROCEDURE IF EXISTS `OilComps_Misc_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `OilComps_Misc_Save`(IN vc_category Varchar(45),IN do_amount double,IN intexperimentId int(10))
BEGIN
SET foreign_key_checks = 0;
insert into oilcomps_misc(category,amount,experiment_id)  values(vc_category,do_amount,intexperimentId);
SET @OilComponent_Mic_Id= LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `OilPhysProps_GetRecentId`
--

DROP PROCEDURE IF EXISTS `OilPhysProps_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `OilPhysProps_GetRecentId`()
BEGIN
Select id from oilphysprops where id=@OilPhysicalPro_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `OilPhysProps_Save`
--

DROP PROCEDURE IF EXISTS `OilPhysProps_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `OilPhysProps_Save`(
  IN do_Density DOUBLE, IN do_Viscosity DOUBLE, IN do_Viscosity_temp DOUBLE,
  IN do_FlashPoint DOUBLE, IN do_PourPoint DOUBLE, IN do_pH DOUBLE, IN do_HHV DOUBLE,
  IN do_HeatOfCombustion DOUBLE, IN do_WaterContent double,IN do_ConradsenCarbon double,IN intExperimentId int(10))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO OilPhysProps(density, viscosity, viscosity_temp, flashPoint, pourPoint,
  pH, HHV, HeatOfCombustion,WaterContent,ConradsenCarbon,experiment_id)
  VALUES(do_Density, do_Viscosity, do_Viscosity_temp, do_FlashPoint, do_PourPoint,
  do_pH, do_HHV, do_HeatOfCombustion,do_WaterContent,do_ConradsenCarbon,intExperimentId);
SET @OilPhysicalPro_id=LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `OilultAna_GetRecentId`
--

DROP PROCEDURE IF EXISTS `OilultAna_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `OilultAna_GetRecentId`()
BEGIN
Select id from Oil_ultAnal where id=@oilUltiAnal_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Oil_ultAnal_Save`
--

DROP PROCEDURE IF EXISTS `Oil_ultAnal_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Oil_ultAnal_Save`(
  IN do_C DOUBLE, IN do_H DOUBLE, IN do_N DOUBLE, IN do_O DOUBLE, IN bl_O_calc BOOL,
  IN do_Cl DOUBLE, IN do_S DOUBLE, IN do_H_C DOUBLE, IN bl_H_C_calc BOOL,
  IN do_O_C DOUBLE, IN bl_O_C_calc BOOL, IN do_Ash DOUBLE, IN do_Water DOUBLE,
  IN vc_WaterMethod VARCHAR(30),IN intexperiment_id int(10))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO Oil_ultAnal(C, H, N, O, O_calc, Cl, S, H_C, H_C_calc, O_C, O_C_calc,
  ash, water, waterMethod,experiment_id)
  VALUES(do_C, do_H, do_N, do_O, bl_O_calc, do_Cl, do_S, do_H_C, bl_H_C_calc,
  do_O_C, bl_O_C_calc, do_Ash, do_Water, vc_WaterMethod,intexperiment_id);
SET @oilUltiAnal_id=LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `PhysProps_GetRecentId`
--

DROP PROCEDURE IF EXISTS `PhysProps_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `PhysProps_GetRecentId`()
BEGIN
Select id from PhysProps where id=@phys_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `PhysProps_Save`
--

DROP PROCEDURE IF EXISTS `PhysProps_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `PhysProps_Save`(
  IN do_Diam_min DOUBLE, IN do_Diam_max DOUBLE, IN do_length1 DOUBLE,
  IN do_length2 DOUBLE, IN do_length3 DOUBLE, IN do_Pred_diam DOUBLE,
  IN do_Moisture_min DOUBLE, IN do_Moisture_max DOUBLE)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO PhysProps (
  diam_min, diam_max, length1, length2, length3, pred_diam, moisture_min,
  moisture_max, ref_fk) VALUES(
  do_Diam_min, do_Diam_max, do_length1, do_length2, do_length3, do_Pred_diam,
  do_Moisture_min, do_Moisture_max, @rfk
  );
SET @phys_id = LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `PhysProps_Update`
--

DROP PROCEDURE IF EXISTS `PhysProps_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `PhysProps_Update`(IN do_Diam_min DOUBLE, IN do_Diam_max DOUBLE, IN do_length1 DOUBLE,
  IN do_length2 DOUBLE, IN do_length3 DOUBLE, IN do_Pred_diam DOUBLE,
  IN do_Moisture_min DOUBLE, IN do_Moisture_max DOUBLE,IN intId int)
BEGIN
update PhysProps
set
diam_min=do_Diam_min,
diam_max=do_Diam_max,  
length1=do_length1, 
length2=do_length2,  
length3=do_length3,  
pred_diam=do_Pred_diam, 
moisture_min=do_Moisture_min, 
moisture_max=do_Moisture_max,  
ref_fk=@rfk
where id=intId;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ProductCal_GetRecentId`
--

DROP PROCEDURE IF EXISTS `ProductCal_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `ProductCal_GetRecentId`()
BEGIN
Select id from ProductCal where id=@pcal_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ProductCal_Save`
--

DROP PROCEDURE IF EXISTS `ProductCal_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `ProductCal_Save`(IN do_GCV DOUBLE)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO ProductCal (GCV, ref_fk) VALUES(do_GCV, @rfk);
  SET @pcal_id = LAST_INSERT_ID();
SET foreign_key_checks = 1;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ProductCal_Update`
--

DROP PROCEDURE IF EXISTS `ProductCal_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `ProductCal_Update`(IN do_GCV DOUBLE,IN intId int)
BEGIN
update ProductCal
set
GCV=do_GCV,
ref_fk=@rfk
where
id=intId;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ProxAnal_GetRecentId`
--

DROP PROCEDURE IF EXISTS `ProxAnal_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `ProxAnal_GetRecentId`()
BEGIN
Select id from ProxAnal where id=@prox_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ProxAnal_Save`
--

DROP PROCEDURE IF EXISTS `ProxAnal_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `ProxAnal_Save`(
  IN vc_MoistureStatus VARCHAR(15), IN do_Moisture DOUBLE, IN do_Ash DOUBLE,
  IN do_Volatiles DOUBLE, IN do_FixedCarbon DOUBLE)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO ProxAnal ( moistureStatus, moisture, ash, volatiles, fixedcarbon, ref_fk) 
  VALUES(vc_MoistureStatus, do_Moisture, do_Ash, do_Volatiles, do_FixedCarbon, @rfk);
SET foreign_key_checks = 1;
SET @prox_id = LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `ProxAnal_Update`
--

DROP PROCEDURE IF EXISTS `ProxAnal_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `ProxAnal_Update`(IN vc_MoistureStatus VARCHAR(15), IN do_Moisture DOUBLE, IN do_Ash DOUBLE,
  IN do_Volatiles DOUBLE, IN do_FixedCarbon DOUBLE,IN intId int)
BEGIN
update ProxAnal
set
moistureStatus=vc_MoistureStatus,
moisture=do_Moisture,  
ash=do_Ash,  
volatiles=do_Volatiles,  
fixedcarbon=do_FixedCarbon, 
ref_fk=@rfk
where
id=intid;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Reference_GetRefId`
--

DROP PROCEDURE IF EXISTS `Reference_GetRefId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Reference_GetRefId`()
BEGIN
select ref_id from reference where ref_id=@rfk;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Reference_Save`
--

DROP PROCEDURE IF EXISTS `Reference_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Reference_Save`(IN vc_Author VARCHAR(300), IN vc_Citation VARCHAR(400),
  IN vc_Organizations VARCHAR(300))
BEGIN
  INSERT INTO Reference (author, citation, organizations)
  VALUES(vc_Author, vc_Citation, vc_Organizations);
  SET @rfk = LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Reference_Update`
--

DROP PROCEDURE IF EXISTS `Reference_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Reference_Update`(IN vc_Author VARCHAR(300), IN vc_Citation VARCHAR(400),
  IN vc_Organizations VARCHAR(300),IN intId int)
BEGIN
update Reference
set
author=vc_Author,
citation=vc_Citation,
organizations=vc_Organizations
where ref_id=intId;

END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Struct_GetRecentId`
--

DROP PROCEDURE IF EXISTS `Struct_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Struct_GetRecentId`()
BEGIN
Select id from struct where id=@struct_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Struct_Save`
--

DROP PROCEDURE IF EXISTS `Struct_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Struct_Save`( IN do_Lignin DOUBLE,IN vc_Lignin_method varchar(30),
  IN do_Cellulose DOUBLE,IN do_Hemicellulose DOUBLE,IN do_Extractives DOUBLE, IN do_CellWall DOUBLE, IN do_Pectin DOUBLE,
  IN do_Sol_Sugars_Stch DOUBLE, IN do_Xylan DOUBLE, IN do_Glucomannan DOUBLE,IN do_galactan DOUBLE,IN do_arabinan DOUBLE,IN do_mannan DOUBLE)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO Struct ( lignin,ligninMethod, cellulose,hemicellulose,extractives,cellwall,pectin, sol_sugars_stch,xylan,glucomannan, ref_fk,galactan,arabinan,mannan)
  VALUES(do_Lignin ,vc_Lignin_method,do_Cellulose,do_Hemicellulose,do_Extractives,do_CellWall, do_Pectin, do_Sol_Sugars_Stch, do_Xylan, do_Glucomannan, @rfk,do_galactan,do_arabinan,do_mannan);
SET foreign_key_checks = 1;
SET @struct_id = LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `UltAnal_GetRecentId`
--

DROP PROCEDURE IF EXISTS `UltAnal_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `UltAnal_GetRecentId`()
BEGIN
Select id from UltAnal where id=@ult_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `UltAnal_Save`
--

DROP PROCEDURE IF EXISTS `UltAnal_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `UltAnal_Save`(
  IN vc_moistureStatus vARCHAR(15), IN do_Moisture DOUBLE, IN do_Ash DOUBLE,
  IN do_H DOUBLE, IN do_C DOUBLE, IN do_N DOUBLE, IN do_O DOUBLE, IN bl_O_calc BOOL,
  IN do_Cl DOUBLE, IN do_S DOUBLE, IN do_H_C DOUBLE,
  IN bl_H_C_calc BOOL, IN do_O_C DOUBLE, IN bl_O_C_calc BOOL)
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO UltAnal(
  moistureStatus, moisture, ash, H, C, N, O, O_calc, Cl, S, H_C, H_C_calc,
  O_C, O_C_calc, ref_fk)
  VALUES(vc_moistureStatus, do_Moisture, do_Ash, do_H, do_C, do_N, do_O, bl_O_calc,
  do_Cl, do_S, do_H_C, bl_H_C_calc, do_O_C, bl_O_C_calc, @rfk);
SET foreign_key_checks = 1;
SET @ult_id = LAST_INSERT_ID();
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `UltAnal_Update`
--

DROP PROCEDURE IF EXISTS `UltAnal_Update`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `UltAnal_Update`(IN vc_moistureStatus vARCHAR(15), IN do_Moisture DOUBLE, IN do_Ash DOUBLE,
  IN do_H DOUBLE, IN do_C DOUBLE, IN do_N DOUBLE, IN do_O DOUBLE, IN bl_O_calc BOOL,
  IN do_Cl DOUBLE, IN do_S DOUBLE, IN do_H_C DOUBLE,
  IN bl_H_C_calc BOOL, IN do_O_C DOUBLE, IN bl_O_C_calc BOOL,IN intId int)
BEGIN
update UltAnal
set
moistureStatus=vc_moistureStatus,
moisture=do_Moisture,  
ash=do_Ash, 
H=do_H,  
C=do_C,  
N=do_N,  
O=do_O,  
O_calc=bl_O_calc, 
Cl=do_Cl,  
S=do_S,  
H_C=do_H_C, 
H_C_calc=bl_H_C_calc, 
O_C=do_O_C,  
O_C_calc=bl_O_C_calc,  
ref_fk=@rfk
where id=intId;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Users_Getpassword`
--

DROP PROCEDURE IF EXISTS `Users_Getpassword`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Users_Getpassword`(IN vcLoginName varchar(50))
BEGIN
Select User_Password from users where Login_Name=vcLoginName;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `users_Save`
--

DROP PROCEDURE IF EXISTS `users_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `users_Save`(IN vcLoginName varchar(50),IN vcFirstName varchar(100),IN vcLastName varchar(100),IN vcEmail varchar(250),IN vcUserPassword varchar(250))
BEGIN
insert into users (Login_Name,First_Name,Last_Name,Email,User_Password) values (vcLoginName,vcFirstName,vcLastName,vcEmail,vcUserPassword);


END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Yields_Save`
--

DROP PROCEDURE IF EXISTS `Yields_Save`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Yields_Save`(IN do_Gas DOUBLE, IN int_gasComFK INT, IN do_Chr DOUBLE,
  IN int_chrCompFK int, IN do_Liquid DOUBLE,IN int_liquidCompFK int,IN do_Tar DOUBLE,IN int_refFK int,IN intexperimentId int(10))
BEGIN
SET foreign_key_checks = 0;
  INSERT INTO Yields(gas, gasComp_fk, chr, chrComp_fk, liquid, liquidComp_fk,tar, ref_fk,experiment_id)
  VALUES(do_Gas, int_gasComFK, do_Chr,int_chrCompFK, do_Liquid,int_liquidCompFK,do_Tar,int_refFK,intexperimentId);
SET @yid = LAST_INSERT_ID();
SET foreign_key_checks = 1;

END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;

--
-- Definition of procedure `Yield_GetRecentId`
--

DROP PROCEDURE IF EXISTS `Yield_GetRecentId`;

DELIMITER $$

/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`Teva`@`localhost` PROCEDURE `Yield_GetRecentId`()
BEGIN
select id from yields where id=@yid;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */  $$

DELIMITER ;



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
